MS SQL 2008 R2 to ASA 11 there are 2 ODBC connections from MS SQL server (32 and 64bit) to the ASA 11 engine. both of the odbc connections work (using the test connection button.) 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) asked 30 Jul '13, 09:23 Tom Mangano Volker Barth |
Possibly that similar FAQ may be of help... answered 30 Jul '13, 09:38 Volker Barth |
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 answered 31 Jul '13, 11:49 JBSchueler |
Thanks for all of the responses. The easy fix was to install the client communications from EBF 2960. answered 06 Aug '13, 12:46 Tom Mangano |