from MS SQL, when executing select * from v_poc_sales MS SQL returns error above. there is an ASA datetime in the view, which i suspect is the problem. it appears that the OLE DB provider is trying to take the ASA datetime and convert it to a string (user_stamp.ToString() as user_stamp) |
The SQL Anywhere database server does not support this type of syntax: "user_stamp.ToString()". DATETIME columns are supported in queries from SQL Server Mgmt Studio. SELECT [datetime_col] FROM [SATEST11].[demo].[DBA].[alltypes] The alltypes table was created using SA's Interactive SQL (dbisql). CREATE TABLE "DBA"."alltypes" ( "bigint_col" BIGINT NULL, -- 1 "binary_col" BINARY(64) NULL, -- 2 "bit_col" BIT NULL, -- 3 "char_col" CHAR(64) NULL, -- 4 "date_col" DATE NULL, -- 5 "datetime_col" "datetime" NULL, -- 6 |
Thanks for all of the responses. The easy fix was to install the client communications from EBF 2960. |