Error Executing Database Query. I/O Error: Connection reset The error occurred in \\nawinfs03\home\users\web\b1235\rh.tommy1\linkmanager\query.cfm: line 1 1 : 2 : select * 3 : from clients SQL select * from clients where inactive = 0 order by cname DATASOURCE key_word SQLSTATE 08S01 Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10 GTB7.1 Remote Address 71.235.94.115 Referrer http://www.keywordperformance.com/linkmanager/access/login.cfm Date/Time 24-Jan-11 09:15 AM Stack Trace at cfquery2ecfm2104324051.runPage(\\nawinfs03\home\users\web\b1235\rh.tommy1\linkmanager\query.cfm:1) at cfApplication2ecfm2087273963.runPage(\\nawinfs03\home\users\web\b1235\rh.tommy1\linkmanager\Application.cfm:2) java.sql.SQLException: I/O Error: Connection reset at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2277) at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:331) at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:534) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.io.DataInputStream.readFully(DataInputStream.java:266) at java.io.DataInputStream.readFully(DataInputStream.java:242) at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826) at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707) at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466) at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2172) ... 7 more