The problem is not just with CF. If you are using a 64 bit edition of windows, then the Jet driver is no longer supported by Microsoft and doesn't work on modern 64bit OS. The only option is to use the workarounds to get a 32bit ODBC DSN setup. This also means you will have hosting problems, as Windows is 64bit only since Server 2008, so you wont be able to setup a CF DSN unless the host is willing to also do this workaround for you or unless they are still running Windows 2003.
See this: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess On Mon, Apr 28, 2014 at 2:57 PM, John Pullam <[email protected]>wrote: > > I have a newly installed CF10 system working on my desktop (developer) > machine, including several working SQL Server datasources. But when I try > to get the Access ones to work I keep running into issues. > > I installed the 32 bit version of ColdFusion in order to bypass the issues > with 64 bit drivers, but the results I get sound similar to what others > have said already. Unfortunately the suggestions and fixes in those > postings don't seem to help in my case. Initially I thought I had this > working but after a reboot, its behaviour changed and the Access > datasources failed, so I deleted them in order to try again. > > Now, when I attempt to add a new datasource, I get the message "The > ColdFusion ODBC Server service is not running or has not been installed. > You may also use the "MS Access with Unicode" driver to connect to MS > Access datasources." > > I did the obvious things such as going into services and manually starting > the service. Also there is no Unicode driver option in the administrator. > > Any ideas? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
