Setting up a Microsoft Access DSN in ColdFusion for 64-bit machines

This article will go over setting up an MS Access Datasource in ColdFusion admin for 64 but machines since this is a done in a non-standard way. For 32 bit machines, setup the DSN as you would normally. The reason for this is as that there are no 64-bit drivers available currently.

• Log into your server through Remote Desktop Connection (instructions for connecting to your server through RDC can be found here).
• Run C:\windows\SysWOW64\odbcad32.exe. Once this opens, go under the System DSN tab. There you will be able to change the Access database file location.

Once the System DSN is updated, open ColdFusion admin (typically http://localhost/CFIDE/administrator when viewed via Remote Desktop), and log in. Make the same change to the DSN there under Data Sources. An error may be displayed still but CF will update the references.