[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