Page 1 of 1

connect ASE, the Executive will cut off when a long SQL

Posted: Tue 25 May 2010 12:57
by samin
When connected to the ASE, UniDAC is ODBC connection, in use, I found some SQL in the implementation of a long time will cut off. Cause to fail.

For example, will be reported:
[MERANT][ODBC Sybase ASE driver][SQL Server]The name 'getd' is illegal in this context. Only constants, constant expressions, or variables allowed here. Column names are illegal.

But my SQL, and there is no 'getd' field, only the 'getdate()', should be here to cut off.

What is the reason, there should be set?

Thank you

Posted: Wed 26 May 2010 11:36
by bork
Hello

Probably ODBC driver has limitation on SQL length. Please provide us a whole SQL that was cut. Also please provide your Sybase ASE database version and the exact name and version of your ODBC driver for Sybase ASE database.