MS SQL to ASA 11 using OLEDB

[t1950]

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)

[jack_schueler]

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

[VolkerBarth]

Possibly that similar FAQ may be of help...

[t1950]

Thanks for all of the responses.

The easy fix was to install the client communications from EBF 2960.