Heath, We had this very same problem on our CFMX6.1 sever a couple of years ago. It was like pulling teeth to get Macromedia to help, but once we had a test case that would produce the problem on demand, they finally looked at it. It turns out that our ODBC driver wasn't thread safe. Using the JDBC/ODBD bridge (read: Type 1 JDBC driver) exasperated this problem.
The solution really is to run a JDBC driver preferably type 3 or type 4. What sort of data are you accessing with your ODBC driver? Chris heath stein wrote: > We are having some trouble with Coldfusion MX 7 on one of our servers. Every > few days for some reason Coldfusion runs into a problem and can not connect > to any of our data sources, bringing all of our sites down. > > Error: Executing Database Query.Timed out trying to establish connection The > specific sequence of files included or processed is: > > When I go to restart Coldfusion, I am able to restart all Coldfusion Services > besides the Coldfusion MX 7 ODBC Server. I have to then actually restart the > server to > get Coldfusion working again. > > Do you think this is a problem with code that we have written on one of our > sites or a problem with Coldfusion on this machine? > > Thanks, > Heath Stein > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
