ColdFusion MX 7 ODBC Server Hanging (MS Access is the terrible database involved)
I've got this super terrible problem with ColdFusion MX 7's ODBC Server hanging. At random times the ODBC server will fail to work and then soon after that all of my queries to the access database via our little intranet application time out. The only way to fix this problem is to kill the service (it will not stop unless you taskkill this baby). And then I restart the services (odbc server, odbc agent, jrun services) and it all starts working again. And then, at some time in the future, it dies again.
I can't, for the life of me, figure out the method I would use to start debugging this problem. I'm also just starting to venture into the ColdFusion space, so your advice would be exceptionally valuable. ODBC tracing, btw, in Windows 2003 does not seem to work. I do get to see the debug information about the timed out database query (I need to wait for the server to die again before I can grab this, unfortunately), but that's essentially all I've got. And I know the ODBC server is hanging and when restarted fixes the issue..
Help! ![]()
