One issue I have seen with Coldfusion server 9 is that if you are using an access database you may have trouble getting the data source to register in the Coldfusion administrator. Specifically what I had seen what when you tried to register, it gave the error:
Variable DRIVERPATH is undefinedThe solution I found on a Adobe forum post that outlined this exact problem. The solution?
Launch the registry editor:
cmd > regedt32Locate the following reg key
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<your data source>\Look for a string called "Driver" inside that folder, if it's not there, create it with the value of "C:\WINDOWS\System32\odbcjt32.dll"
For us, that fixed the problem, thanks to Rob D from that post.