[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] FreeTDS (on FreeBSD) lost connection
From:       liam () inodes ! org
Date:       2005-06-30 6:25:29
Message-ID: 20050630062529.GA18310 () inodes ! org
[Download RAW message or body]

On Mon, Jun 27, 2005 at 10:36:03AM -0400, Lowden, James K wrote:

> TDS_DEAD.  (But there might be code paths that don't?)  I think the OP
> need only check the state.  

This is mostly what my original network timeouts patch was made to
address as I loose connectivity to my MSSQL server semi regularly 
and am able to detect the problem and take appropriate action using
dberrhandle() and dbmsghandle() functions. 

I also wrote my own pooling library on top of dblib and I refresh
all connections (that is tear down and re-open) at a regular interval.

If you do the above and grab the latest snapshot of FreeTDS from CVS, I'm 
sure your application will behave nicely.

One thing I do know that FreeTDS does not cope nicely with is rapidly
making multiple connections to the remote MSSQL server (MSSQL will
eventually refuse connections from the host) and then the TDS structures 
appear to get messed up.

Cheers.
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]