ColdFusion 9 ODBC Server will not start
Ran into a weird issue with a customer today, their CF9 ODBC server would not start. It was giving this error in event viewer.
ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open event trace file because the file version is not recognised.
I couldn't find anything on Google so I drilled down into the folder that contained the exe's for running ODBC. C:\ColdFusion9\db\slserver54\bin. I noticed a folder called tracing one directory above this. I renamed it and created a new empty folder named "tracing" and the services started without any issue. Deleting the ColdFusion 9 ODBC Agent.trc and ColdFusion 9 ODBC Server.trc files would probably do the same trick. Thought I would share in case anyone else is struggling with this.
April 19th, 2011 - 09:26
Great find… thanks! I deleted the two .trc files (as I was slightly confused by your directions regarding the tracing folder being one directory above, which I didn’t at first realise was with reference to the .trc files) and lo and behold, the 2 ODBC Services fired up!
Nice work
April 20th, 2011 - 12:27
np, and what a great feeling too when you find it’s something simple and easy!
May 8th, 2011 - 10:17
It works. Great tip! After few hours research without luck then I found your tip using Google. You should post it on Adobe forum. Thanks Mike! Happy Mother’s Day.
June 30th, 2011 - 14:20
Just had the same problem and deleting the 2 files worked. Thanks a ton!
September 9th, 2011 - 11:09
Great tip. It worked for me too.