Dave, Thank you for the links. The first link (for CF MX and higher) did not work on my system (CF8 on W2008 R2), but the second link (reinstalling CF8 ODBC services manually) did the trick. The services are up and running again, and the databases are accessible.
Just for future reference, I'm listing all the possible solutions I found on several threads, so that they are all mentioned in one place: - Solution 1: If CF was installed by double-clicking the installation file, this may have not created a path to the 32-bit drivers. Installing CF by right-clicking the installation file and selecting "Run as Administrator" (even though you may be logged in already with an administrator account) would ensure the installation process has all the permissions required to create all paths. This solution is explained in comment 7 of this thread: http://forums.adobe.com/message/230023#230023 - Solution 2: Tricking the CFIDE Administrator to create the necessary Registry key entry. This solution (together with an alternative for W2003) is explained at http://www.coldfusionmuse.com/index.cfm/2010/12/31/Access.on.64bit.ColdFusion - Solution 3: Creating a registry entry for the 32-bit drivers. This solution is explained in comment 6 of this thread: http://forums.adobe.com/message/230023#230023 - Solution 4: Installing the 64-bit ODBC Admin Tool from Microsoft. This solution is explained at http://jamiekrug.com/blog/index.cfm/2010/10/14/railo-access-dsn-64-bit-windows - Solution 5: There is a JDBC driver available that addresses the MS Access connectivity issue and has been reported to work with CF8. They have a trial version. Here's a link to that product: http://www.hxtt.com/access.html - Solution 6: Using the "MS Access with Unicode" drivers that CF has. This would bypass the Windows ODBC, but further tests are needed to make sure text is stored to and retrieved from the database(s) properly. - Solution 7: If the issue is with the CF ODBC services, reinstall the services manually. The instructions for CF MX are at http://kb2.adobe.com/cps/191/tn_19135.html and the instructions for CF8 are at http://kb2.adobe.com/cps/402/kb402637.html . - Solution 8: Moving the database(s) to the free SQL Server Express, mySQL, or PostgreSQL as they are completely compatible with CF. Thanks again. At 09:45 PM 11/20/2011, Dave Watts wrote: >Re: CF8 and ODBC services > > > > > > >---------- >Actually, I think you should be able to use a 32-bit version of CF >with Access datasources on a 64-bit version of Windows. The problem >occurs when you also use a 64-bit version of CF. > >You may need to reinstall SequeLink (the ODBC Server and ODBC Agent >services). There's a technote on how to do this on the Adobe site. > ><http://kb2.adobe.com/cps/191/tn_19135.html>http://kb2.adobe.com/cps/191/tn_19135.html > > > >There's another technote that describes a similar, but not identical, problem: > ><http://kb2.adobe.com/cps/402/kb402637.html>http://kb2.adobe.com/cps/402/kb402637.html > > > >The Access with Unicode driver works well enough, in my somewhat >limited experience. It uses a JET bridge instead of an ODBC bridge. >There are some cases where the JET driver works better than the ODBC >driver, and vice versa. I haven't run into any character rewriting >with them, though. > >All that said, I would strongly recommend that you start migrating >from Access to ... almost anything else. > >Dave Watts, CTO, Fig Leaf Software ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
