The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

edited 30 Jul '13, 09:37

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644


Possibly that similar FAQ may be of help...

permanent link

answered 30 Jul '13, 09:38

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644
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
1.9k2836
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
587182234
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:

×123
×28

question asked: 30 Jul '13, 09:23

question was seen: 655 times

last updated: 06 Aug '13, 12:46