FreeTDS Development Group

["Gene Sokolov" <hook AT aktrad.ru>]

Check out this mailing list around May 17 2000 "Problem with long queries"
The workaround is to set tds->out_buf size to something bigger than the
default value of 512. I have no idea how to really fix this problem.

Gene Sokolov.

From: "Rusty Conover" <rconover AT zootweb.com>
> FreeTDSers,
>
> I'm experiencing some trouble with FreeTDS and an insert statement that is
over
> 512 bytes in length being sent properly to a MSSQL 7.0 Server.  I am using
> FreeTDS version 0.5 with TDS version 7.0 compiled.
>
> The situation is that there is a varchar column with a width of 6000 bytes
and
> I'm trying to put 4000+ bytes into it in a single SQL query.  TDS only
> successfully processes a query length of 504 (due to the eight bytes
header I assume)
> bytes total.  The actual number of bytes that make it into the column
depends on
> the actual length of the SQL since it seems that there is a 504 byte hard
limit to
> the SQL query to be successfully processed.  I have traced through the
write.c
> code and have noted that the last packet indicator is being set correctly.
The
> problem is that the row never appears in the SQL server.
>
> Has anybody run into this problem before?
>
> Rusty
> --
> ---------------------------------------------
> Rusty Conover        | rusty AT zootweb.com
> Systems Programmer   | 406-586-5050 x242
> Zoot Enterprises     | http://www.zootweb.com
> ---------------------------------------------
>
> "Nullum magnum ingenium sine mixtura dementiae fuit." -- Seneca
>
>
>
> ---
> You are currently subscribed to freetds as: hook AT aktrad.ru
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>
>