John, I am going to focus on your actual error 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.*
This is going to sound a bit basic, but did you actually install the ODBC drivers when you installed ColdFusion? I have not used Access since 1995, so I am only gasping at the hope that is what maybe the problem. Just out of curiosity, I know you mentioned the reason behind this in another thread, but is there any chance that this maybe the time to just bite the bullet and export the data into a SQL DB? Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Tue, Apr 29, 2014 at 5:33 AM, John Pullam <jpul...@mcleansystems.com>wrote: > > >Are you able to manually create a 32-bit ODBC connection to your Access > >database? If you weren't aware already, you need to run the 32-bit > >Windows ODBC data sources applet from inside \Windows\SysWOW64 to access > >the 32-bit stuff. If you can do that successfully, then try connecting > >to that 32-bit ODBC data source from within CF Administrator. > > If you mean can I run C:\Windows\SYSWOW64\odbcad32.exe, the answer is yes. > It allows me to select an Access datasource and to specify the mdb file. > But when I go back into the CF administrator I again get that error message > when I try an add of a Microsoft Access > file. > > You said that I should try connecting it with the administrator. Does that > mean something other than trying to add it as I have done? > > I'm still unable to get past that error "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." > > Any ideas would be appreciated... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:358446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
