[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