FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

"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