Cold Fusion Query Error
Posted on 2006-11-03
I have a customer that is using cold fusion pages and receives the following error intermittently when going to his home page: The error does not occur every time and I am able to get to the page 1 out of 3 tries?? Can anyone help with what could be causing this. Also I placed a test .cfm page in his home dir that goes to a access db to do a select. This was not succesfull, however it worked fine in another site on the same server. I also tried moving to an independant application pool...no luck .. Coud this have something to do with session ????? Thanks for any help!!!!
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]Internal network error, connection closed.
The error occurred in \\frigga\home\users\web\b715\hoc.cmadmin\acb\Shared\project.cfm: line 28
Called from \\home\users\web\b715\\acb\Application.cfm: line 4
Called from \\home\users\web\b715\acb\Shared\project.cfm: line 28
Called from \\home\users\web\b715\acb\Application.cfm: line 4
26 : <CFELSE>
27 : CompanyDatasources.CompanyDS_ID = 1
28 : </CFIF>
29 : ORDER BY CompanyDatasources.CompanyName
30 : </CFQUERY>
SQL SELECT * FROM DataSourceMaster, CompanyDatasources WHERE DataSourceMaster.DataSources_ID = CompanyDatasources.DataSources_ID AND CompanyDatasources.CompanyDS_ID = 6 ORDER BY CompanyDatasources.CompanyName