Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem when the SQLExecute failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem when the SQLExecute failed
  • Date: Mon, 29 Nov 2004 20:59:30 -0500

"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




Archive powered by MHonArc 2.6.24.

Top of Page