Error Executing Database

[coreygrimm]

My coldfusion service crashes intermitantly and when I check the application
logs the error that I see for the time frame is the one below. Does anyone know
where I might begain to solve this? Thanks!

Error Executing Database Query.coldfusion.sql.DatabaseConnectionException:
Timed out trying to establish connection The specific sequence of files
included or processed is: E:\wwwroot\lifeworks\default.cfm

[MichaelSJudd]

I'm no expert, but thought I would try to be helpful.

I was getting this same error on a regular basis.

The short term fix was to restart the ODBC server service. The long term fix
was twofold:

1. I recreated the ODBC connection in ColdFusion Administrator to use the
system connection (I was using the SA and PW for login).

2. I created a second user ODBC connection as well as the system one under
ODBC in Windows Server 2003.

I haven't had the problem since.

I also read a pretty good set of "stuff" to try from the help area:

[url]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_17277[/url]

Hope this helps.