You could also use a Java driver to communicate with Access http://www.hxtt.com/access.html. I use this driver on my Mac to work on some older sites that I have to support and are using Access.
On Mon, Apr 28, 2014 at 10:10 AM, Russ Michaels <[email protected]> wrote: > > 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:358438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
