Steven - that sounds accurate, however, I dont know that our SQL server is being resst as often as I am seeing the errors. I get the time-outs and a very frequent basis.
-Jim Helmbrecht >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 > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
