ColdFusion 8: Database Connection Reset Error
I am getting these intermittent ColdFusion Database reset connections and was wondering if anyone had any experience with this and what specific solution worked?
Here is the error:
Database query execution error. [Macromedia] [JSBC SQLServer Driver] There was a problem trying to contact the server (server returned: connection reset). Make sure that the server parameters passed to the driver are correct and that the server is running. Also make sure that the maximum number of connections has not been exceeded for this server.
It doesn't happen with any particular query, the code breaks in different queries every time, returning SQLSteate 08s01 error. These query logics are fine, no logic errors, etc. I checked the network logs and there were no database server connection failures at the time of the error. Once the first error occurs, it continues to occur for no more than a minute or so at random times in the day, every few days. I was looking for this thing and so far anyone who had this problem was only on CF6 or 7, which coldFusion fixes were only released for CF6 or 7.
Server config:
- ColdFusion Server is version 8
- The database server is SQL Server 2005 Standard
- Allowed database connections for SQL Server and ColdFusion option
Any help would be greatly appreciated, thanks!
a source to share
I will personally try to update the JDBC driver ( http://sourceforge.net/projects/jtds/ ) and add a validation request if it doesn't already exist. I used a tool that constantly checked TCP connections between servers, found even a millisecond break, checked this tool http://www.colasoft.com/ping_tool/ .
a source to share
Have you already solved the problem?
I have the same problem on a CF8 VPS and after some research on the internet I found this post: http://www.mail-archive.com/ cf-talk@houseoffusion.com /msg302264.html It says it is related with some functionality on the network card and something on SP2 for Win2k3 that messed it up. I don't know if this applies to you, but just in case.
a source to share