Hi,
I am getting lots of errors on our cf server like
Error Diagnostics: ODBC Error Code = ()<P> Unable to get a connection
to [datasource name].<BR><BR>Reason: 30 second timeout limit
exceeded.<BR><BR><P><P>SQL = "SELECT * FROM Products
WHERE ID = 38"<P>Data Source = "[datasource name]"<P><p>The error
occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (4:1) to (4:57) in the template file
F:\INETPUB\WWWROOT\cOPS\QRY\QRY_GETPRODUCTS.CFM.</p>
Date Time: 02/26/03 23:37:03
IP Address: 195.xx.xx.xx
Browser: Mozilla/4.0 (compatible; MSIE 6.0; AOL 7.0; Windows NT 5.1; .NET
CLR 1.0.3705)
When I check the odbc connection it is fine and verified ok. Also, other
pages on the website which use the same database connection work fine. Then
I need to restart the CF service and this page also starts working. This has
been happening sometimes on other websites also and restarting CF seems to
correct it.
Also, sometimes I am getting errors like
Unable to get a connection to __QM__.<BR><BR>Reason: 30 second timeout limit
exceeded.<BR><BR><P> <P>SQL = "SELECT Title
FROM sections where id = 1"<P>Data Source = "datacli"<P><p>The error
occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (111:1) to (111:66) in the template file
F:\INETPUB\WWWROOT\cOps\QRY\QRY_HEADER.CFM.</p>
We do not have a dsn called __QM__ and it seems to connecting to a dsn which
is does not exist.
These errors started only a few days back and could not find any related
logs/errors in windows.
Please can anyone help me find out why the errors could be occuring or
something that i need to check. Any help much appreciated...
Thanks in advance,
Sandeep
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
