Recently, I upgraded the last of the CFMX 6.0 systems here at my company to CFMX 6.1. I ran into a small problem after the upgrade where the ODBC Server and ODBC Agent services, used by ColdFusion to allow connections to ODBC datasources would not start. I had run into this before, but I couldn't quite remember what the issue was (one more reason for documenting your installs and upgrades).

To make a long story short, ColdFusion was installed on the D drive of this machine, which was the root of the problem. Apparently, when you install/upgrade CFMX on a drive other than C (Windows), the .ini files used by the two services in question get incorrect drive/directory references.

The solution for the problem is to do a search and replace all instances of:

C:\Program Files\Merant\

with

D:\CFusionMX

in the directory D:\CFusionMX\db\slserver52 and all of its subdirectories. This assumes your install is on the D drive.

More information can be found in Macroemdia Technote 18800.