The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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
632232636
accept rate: 6%

edited 30 Jul '13, 09:37

Volker%20Barth's gravatar image

Volker Barth
32.3k328474691


Possibly that similar FAQ may be of help...

permanent link

answered 30 Jul '13, 09:38

Volker%20Barth's gravatar image

Volker Barth
32.3k328474691
accept rate: 32%

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

JBSchueler
2.2k2939
accept rate: 16%

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
632232636
accept rate: 6%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×137
×29

question asked: 30 Jul '13, 09:23

question was seen: 1,067 times

last updated: 06 Aug '13, 12:46