Skip to main content
Participant
November 24, 2009
Question

ColdFusion MX 7 ODBC Server Hanging (MS Access is the terrible database involved)

  • November 24, 2009
  • 1 reply
  • 915 views

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!

    This topic has been closed for replies.

    1 reply

    Inspiring
    November 24, 2009

    Have you tried the Access Unicode driver? That one doesn't use ODBC.

    aiduserAuthor
    Participant
    November 24, 2009

    I have not -- this is a system I inherited, so I'm just trying to debug it and keep it running while I write another iteration of the system in another language.

    Inspiring
    November 25, 2009

    aiduser wrote on 11/24/2009 5:32 PM:

    I have not -- this is a system I inherited, so I'm just trying to debug it and keep it running while I write another iteration of the system in another language.

    If it works, switching from the ODBC to the Unicode driver is probably

    the easiest way to solve your problem. Try it