I updated a windows 2003 server from coldfusion MX 6 to coldfusion9. On two different cf applications the server comes back with data source could not be found. Data sources were added to the (Data and Services) data sources tab under the administrator settings. Connection status to databases verified ok. CF page referencing no datasources work fine. Only when datasources referenced does the application fail. To be honest CF scripting is not my forte. Dream Weaver primary tool I use. I do have CFMX7 1300 page book I use for reference. When I reload CFMX 6 and add datasources to data sources tab, CFM pages work fine and I get no database errors. Any help you can provide very much appreciated. My understanding is applications working with CFMX 6 should work fine with CF9. Here is a copy of the CF debug for two different applications when using CF9. Application 1 The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Datasource hrsconfig could not be found. The error occurred in C:\Inetpub\wwwroot\hrsconfig\default.cfm: line 23 Called from C:\Inetpub\wwwroot\hrsconfig\default.cfm: line 1 Called from C:\Inetpub\wwwroot\hrsconfig\default.cfm: line 23 Called from C:\Inetpub\wwwroot\hrsconfig\default.cfm: line 1 21 : <CFQUERY NAME="checkAccessLog" DATASOURCE="HRSConfig" MAXROWS=1>SELECT ID FROM accessLog</CFQUERY> 22 : <CFCATCH> 23 : <CFQUERY NAME="create" DATASOURCE="hrsconfig"> 24 : CREATE TABLE "accessLog" ( 25 : "ID" counter primary key, DATASOURCE hrsconfig 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.0; en-US; rv:1.9.1.13) Gecko/20100914 SeaMonkey/2.0.8 Remote Address 10.101.3.4 Referrer Date/Time 14-Oct-10 10:13 AM Stack Trace at cfdefault2ecfm701521087._factor16(C:\Inetpub\wwwroot\hrsconfig\default.cfm:23) at cfdefault2ecfm701521087.runPage(C:\Inetpub\wwwroot\hrsconfig\default.cfm:1) at cfdefault2ecfm701521087._factor16(C:\Inetpub\wwwroot\hrsconfig\default.cfm:23) at cfdefault2ecfm701521087.runPage(C:\Inetpub\wwwroot\hrsconfig\default.cfm:1) java.sql.SQLException: Datasource hrsconfig could not be found. at coldfusion.sql.DataSrcImpl.validate(DataSrcImpl.java:95) at coldfusion.sql.SqlImpl.validate(SqlImpl.java:280) at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:479) at cfdefault2ecfm701521087._factor16(C:\Inetpub\wwwroot\hrsconfig\default.cfm:23) at cfdefault2ecfm701521087.runPage(C:\Inetpub\wwwroot\hrsconfig\default.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Application 2 The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Datasource northgrum could not be found. The error occurred in C:\Inetpub\wwwroot\northgrum\initiallogin.cfm: line 3 1 : <cfset CurrentPage=GetFileFromPath(GetTemplatePath())> 2 : <cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ "form1"> 3 : <cfquery datasource="northgrum"> 4 : UPDATE Employees SET Password= 5 : <cfif IsDefined("FORM.Password") AND #FORM.Password# NEQ ""> DATASOURCE northgrum 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.0; en-US; rv:1.9.1.13) Gecko/20100914 SeaMonkey/2.0.8 Remote Address 10.101.3.4 Referrer http://10.101.3.3/wwwroot/northgrum/initiallogin.cfm Date/Time 14-Oct-10 10:28 AM Stack Trace at cfinitiallogin2ecfm1312023425.runPage(C:\Inetpub\wwwroot\northgrum\initiallogin.cfm:3) at cfinitiallogin2ecfm1312023425.runPage(C:\Inetpub\wwwroot\northgrum\initiallogin.cfm:3) java.sql.SQLException: Datasource northgrum could not be found. at coldfusion.sql.DataSrcImpl.validate(DataSrcImpl.java:95) at coldfusion.sql.SqlImpl.validate(SqlImpl.java:280) at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:479) at cfinitiallogin2ecfm1312023425.runPage(C:\Inetpub\wwwroot\northgrum\initiallogin.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
I would set up the simplest possible sample page with the simplest possible query, and perform a dump: <cfquery name="qTest" datasource="hrsconfig"> select id from accesslog </cfquery> <cfdump var="#qTest#" /> From there, I would: 1) triple check the name of the datasource 2) be consistent with casing 3) run the page again If that doesn't work, if possible, I would: 4) remove the datasource 5) add the datasource back with the same name 6) verify the connection in the cf administrator 7) rerun the page If that doesn't work, I would: 8) add a brand new datasource with a different name 9) verify the connection 10) rerun the page with the new datasource name Really just some basic troubleshooting ideas. I hope something in here helps because I know this can be very frustrating. Good luck!
Thanks so much for the info. I was able to figure this out a while back. You were absolutely correct with your suggestions. Although the datasource connector in the coldfusion admin was working, the cfm datasource name was off by a character causing the delima. After correcting the name of the datasource the web page worked fine.