[unixODBC-support] Issue with long queries with FreeTDS

Cristian Mammoli cristian.mammoli at gmail.com
Fri Oct 24 14:03:45 BST 2008


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




More information about the unixODBC-support mailing list