[freetds] Problem when the SQLExecute failed
James K. Lowden
jklowden at schemamania.org
Mon Nov 29 20:59:30 EST 2004
"ou liu" <ou at qbt.com> wrote:
> I got problems when I was trying to do SQLExecute and the
> connection
> to server is down. The error log looks like:
> [FreeTDS][SQL Server]Write to SQL server failed. 08S01
>
> I am trying to reproduce problem by disconnecting the cable on the
> SQL server, but I can only reproduce following error
> [FreeTDS][SQL Server]Read from SQL server failed. 08S01
...
> 2. How can I reproduce the " Write to SQL server failed".
You should be able to reproduce that error with tsql, I think. (You're
looking to fix the FreeTDS code, or your application's response?)
The trick is to break the connection after a result set has been
completely processed, and before attempting to send a new query to the
server.
Does that help?
--jkl
More information about the FreeTDS
mailing list