css

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).

1 comment:

ColdFusion Developer said...

Thank you for the information. Make sure you add the direct path to the MDB in the "Database File" field in the CF Administrator as well as the "C:\windows\system32\system.mdw" in the "System Database File" field.