andrew_89
asked on
Cold Fusion Query Error
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\b7 15\hoc.cma dmin\acb\S hared\proj ect.cfm: line 28
Called from \\home\users\web\b715\\acb \Applicati on.cfm: line 4
Called from \\home\users\web\b715\acb\ Shared\pro ject.cfm: line 28
Called from \\home\users\web\b715\acb\ Applicatio n.cfm: line 4
26 : <CFELSE>
27 : CompanyDatasources.Company DS_ID = 1
28 : </CFIF>
29 : ORDER BY CompanyDatasources.Company Name
30 : </CFQUERY>
SQL SELECT * FROM DataSourceMaster, CompanyDatasources WHERE DataSourceMaster.DataSourc es_ID = CompanyDatasources.DataSou rces_ID AND CompanyDatasources.Company DS_ID = 6 ORDER BY CompanyDatasources.Company Name
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]Internal network error, connection closed.
The error occurred in \\frigga\home\users\web\b7
Called from \\home\users\web\b715\\acb
Called from \\home\users\web\b715\acb\
Called from \\home\users\web\b715\acb\
26 : <CFELSE>
27 : CompanyDatasources.Company
28 : </CFIF>
29 : ORDER BY CompanyDatasources.Company
30 : </CFQUERY>
SQL SELECT * FROM DataSourceMaster, CompanyDatasources WHERE DataSourceMaster.DataSourc
I think you mentioned that this was a query agains an MSAccess db. Check that this site and other sites as well, are not set to persistant connection in the odbc properties page of admin. It's possible something else is holding the db locked, and the error is just obscure.
The fact that you get it 1 out of 3 times, or tried it from 1 site and another could all be dumb luck of timing when one site or another lets go of the lock.
The fact that you get it 1 out of 3 times, or tried it from 1 site and another could all be dumb luck of timing when one site or another lets go of the lock.
ASKER
I have managed to isolate this issue to 3 boxes out of a 5 node web farm. I have removed these 3 boxes from serving pages as a test and this page comes up fine. So, this has to be a local configuration that is causing this. I will look into the cold fusion odbc settings and see if there is any issue there.
ASKER
forgive me for asking as I am not very familiar with cold fusion or IIS for that matter....... Where would I look for the odbc persistent connections config. Is tihs a cold fusion setting or IIS??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
There is a data sources within cold fusion but I see no odbc data sources and iterstingly when I go to look at system dnss through windows the window jsut disappears. Someone may have created a local securtiy policy to disbale access to this ??
thanks!