I've seen a couple of weird problems like that when the web server was having problems with it's DNS resolution. That's only relevant if your db is found through DNS of course (which is complicated on Windows with the whole NetBIOS/AD/etc acting as DNS).
In those cases, I just added an entry to the hosts file to hardcode it and problem resolved. That assumes it really IS your problem. It's probably worth looking at the DNS resolution on the web server to the db server if you don't find another obvious cause. On 5/14/07, Jim H <[EMAIL PROTECTED]> wrote: > Has anyone ever dealt with this? I lose a steady ping to the database from > the web server, but a ping to the gateway does not fail. Any thoughts? > > line 4 of route.cfm is: > > 3 <cfquery datasource="#datasource#" name="getCompanyURLs" timeout="15"> > 4 SELECT CompanyURL, CID FROM WebCompanies WHERE > CompanyURL='#cgi.HTTP_HOST#' > 5 </cfquery> > > "Error","jrpp-12","05/10/07","15:26:43","SchoolSites","Error Executing > Database Query.[Macromedia][SQLServer JDBC Driver]A problem occurred when > attempting to contact the server (Server returned: Connection reset). Please > ensure that the server parameters passed to the driver are correct and that > the server is running. Also ensure that the maximum number of connections > have not been exceeded for this server. The specific sequence of files > included or processed is: C:\Inetpub\WebSites\route.cfm, line: 4 " > coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing > Database Query. > at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) > at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:4) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) > at > coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225) > at > coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) > at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) > at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) > at > coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) > at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) > at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) > at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) > at > coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) > at coldfusion.CfmServlet.service(CfmServlet.java:107) > at > coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) > at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) > at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) > at > jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) > at > jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) > at > jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) > at > jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) > at > jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) > at > jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) > "Error","jrpp-12","05/10/07","15:27:18","SchoolSites","Error Executing > Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: > socket write error The specific sequence of files included or processed is: > C:\Inetpub\WebSites\route.cfm, line: 4 " > coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing > Database Query. > at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) > at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:4) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) > at > coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225) > at > coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) > at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) > at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) > at > coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) > at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) > at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) > at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) > at > coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) > at coldfusion.CfmServlet.service(CfmServlet.java:107) > at > coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) > at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) > at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) > at > jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) > at > jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) > at > jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) > at > jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) > at > jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) > at > jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
