[unixODBC-support] Issue with long queries with FreeTDS

Nick Gorham nick.gorham at easysoft.com
Fri Oct 24 09:27:30 BST 2008

Cristian Mammoli wrote:

> Hi I have a problem with a query with FreeTDS driver. Performing a 
> long query (1322 characters) with isql results in [ISQL]ERROR: Could 
> not SQLExecute. A shorter one (300 characters) works like a charm. The 
> query is syntactically correct and works great with the FreeTDS tools 
> such as bsqldb and tsql.

Check that isql is using a big enough line buffer. Its set using the -s 

echo some sql | isql -s 4000 wine_40 sa essentia

If it still fails, I would use the freetds logging to see whats going wrong.

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list