Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

alt textMS 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%20Mangano's gravatar image

Tom Mangano
accept rate: 8%

edited 30 Jul '13, 09:37

Volker%20Barth's gravatar image

Volker Barth

Possibly that similar FAQ may be of help...

permanent link

answered 30 Jul '13, 09:38

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

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
permanent link

answered 31 Jul '13, 11:49

JBSchueler's gravatar image

accept rate: 20%

Thanks for all of the responses.

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

permanent link

answered 06 Aug '13, 12:46

Tom%20Mangano's gravatar image

Tom Mangano
accept rate: 8%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 30 Jul '13, 09:23

question was seen: 2,525 times

last updated: 06 Aug '13, 12:46