Wednesday, May 5, 2010
Connect to a local Microsoft Access 32 bit database from coldfusion 9 64 bit.
Follow the instruction on the following link http://forums.adobe.com/message/2000549. In short copy the Windows\SysWOW64\odbcad32.exe to Windows\System32\odbcad32.exe. Make sure you have backup of both files. Enter the new Windows\System32\odbcad32.exe file. Add the dns. Then add the dns through the coldfusion administrator (for the System Database File use - C:\windows\system32\system.mdw) . It will give an error don't worry it will work ( at least for me).