Skip to main content
November 20, 2011
Answered

Coldfusion 9 ODBC Agent & ODBC Server not starting

  • November 20, 2011
  • 3 replies
  • 11259 views

Hello !

I currently have Coldfusion 9 Enterprise Edition 64 bit installed on a Windows 2008 R2 64 bit server.  I did not notice this before but on this server, both the Coldfusion 9 ODBC Agent & Server services will not start.  I have tried starting them but they start for a second and then stop.  A dialog box then gets displayed which says "The Coldfusion 9 ODBC Agent service on Local Computer started and then stopped.  Some services stop automatically if they are not in use by other services or programs".  I have checked the event viewer on the server and I am seeing the following messages on the enterprise edition server.

The description for Event ID 0 from source ColdFusion 9 ODBC Agent cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ColdFusion 9 ODBC Agent@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open event trace file because the file version is not recognised.

The description for Event ID 0 from source ColdFusion 9 ODBC Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open event trace file because the file version is not recognised.

The strange this is that I have Coldfusion 9 Standard Edition 64 bit also installed on another Windows 2008 R2 64 bit server and both of the ODBC services on that machine are starting fine.  I have checked the account these services are running under on both servers and both services on both machines are running under the local system account so I am not sure if it is permission related or not.

I would appreciate it if some could assist me in getting these services started and what I need to do.

Thank you.

Ed

    This topic has been closed for replies.
    Correct answer

    To anyone that is interested, I have solved this problem by deleting all of the .trc files in folder C:\ColdFusion9\db\slserver54\tracing.  Once that was done, I was able to successfully start the ODBC Server & ODBC Agent services.

    Ed

    3 replies

    Wayne_Vanderlois_409
    Participant
    February 4, 2015

    This also worked in CF11..... not sure what causes it though... that would be nice to know.

    Carl Von Stetten
    Legend
    February 4, 2015

    Has anyone bothered to file a bug report for this issue (I just searched the bug tracker and couldn't see one that applied to this issue)?  I see this has bit several people already, but unless you file an official bug report, Adobe won't know.  They don't monitor these forums with an eye to identifying bugs.

    -Carl V.

    Participant
    February 20, 2014

    Also worked for me too in CF 10.  Thanks.

    Participating Frequently
    November 21, 2011

    Anything in the log files ? (cf_home/logs and cf_home/runtime/logs)

    --

    Mack

    November 21, 2011

    No.  I found no additional information in those logs.

    Ed

    Correct answer
    November 22, 2011

    To anyone that is interested, I have solved this problem by deleting all of the .trc files in folder C:\ColdFusion9\db\slserver54\tracing.  Once that was done, I was able to successfully start the ODBC Server & ODBC Agent services.

    Ed