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

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
samin
Posts: 16
Joined: Mon 10 May 2010 03:58

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

Post by samin » Tue 25 May 2010 12:57

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
Top
bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Wed 26 May 2010 11:36

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.
Top
Post Reply

Return to “Universal Data Access Components”