I've reproduced the Connection Reset error in the following scenario: Reproducible Scenario: 1) With connection pooling enabled, make one simple query with a simple test table to establish the driver connection. 2) Restart the SQL Server database server via Windows Services 3) When SQL Server Service is running again, repeat step 1 to run the simple query. A "Connection reset by peer: socket write error" will occur.
In this scenario ColdFusion driver has established a database connection via TCP and has cached it. Upon a database restart the database terminates the TCP connection. When the query is rerun the cached connection is used however the underlying connection no longer present or functional. Rather than quietly establishing a new connection as retry, the database driver simply propagates the error back to the application. I've submitted the full test case details to the driver vendor DataDirect. We anticipate a fix where the driver will silently make a new connection upon a Connection Reset rather than stopping on the error. -Steven Erat > -----Original Message----- > From: Jim H [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 27, 2007 1:29 PM > To: CF-Talk > Subject: Re: Problem with Server Timing Out > > I upgraded the drivers to the article's specs and the problem > persists. > I will try and collect the other data from CFSTAT. We > installed FusionRactor on the server, however, I have not > been able to deeply understand what it is showing me. I see > connection times ramp up, then time out and fall off. Due to > the errors, it appears like they are DB connections that ramp > up, stall and fail. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
