[unixODBC-support] Issue with long queries with FreeTDS

Nick Gorham nick.gorham at easysoft.com
Fri Oct 24 14:16:02 BST 2008

Cristian Mammoli wrote:

> Nick Gorham ha scritto:
>> 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 option
>> echo some sql | isql -s 4000 wine_40 sa essentia
> This way it doesn't even connect:
> echo "sql" | isql -s 4000 wine_40 sa essentia
> [ISQL]ERROR: Could not SQLConnect
> Maybe I'm using an outdated version?
> [root at faxapra ~]# rpm -qa|grep unixODBC
> unixODBC-2.2.11-7.1
> Thanks
Should be ok, the -s option was added in 2.2.3

Maybe miss the space between the -s and the number.

Add a -v and see what the error is.

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

More information about the unixODBC-support mailing list