I'm using this external dialect with sqla and a database with these properties:
DBMS: ASE (ver. 15.70)
Case sensitivity: plain=exact, delimited=exact
Driver: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase (ver. 1.3.1, JDBC3.0)
Effective version: Sybase ASE (ver. 15.7.0)
The limit clause won't work for me. I get the following error:
(pyodbc.ProgrammingError) ('42000', \"[42000] [FreeTDS][SQL Server]Incorrect syntax near the keyword 'ROWS'.\\n (156) (SQLPrepare)\")\n[SQL: SELECT ...]
From digging on the web i've found that the LIMIT/OFFSET syntax has been introduced in Sybase 16..
Maybe you should specify somewhere on the doc that all feature are available with database > v16.
Hi
I'm using this external dialect with sqla and a database with these properties:
The limit clause won't work for me. I get the following error:
From digging on the web i've found that the LIMIT/OFFSET syntax has been introduced in Sybase 16.. Maybe you should specify somewhere on the doc that all feature are available with database > v16.
Thanks :)