Hi, I'm trying to get an understanding of the 32 vs 64 bit vsns of CF 9 and how they interact with DSNs.
I've had a server running with a 32 bit vsn of CF (Win 2008) and decided to migrate it to a 64 bit test box (Win 2008 R2) with the 64 bit version of CF 9 on it. The DSNs pointing to the Access databases all choked. Ran that to ground and found that I needed to install the 32 bit add-on for Access (AccessDatabaseEngine.exe) from Microsoft. The issue I'm having is when I define a DSN pointing to Access, CF points to the 64 bit vsn of Access ODBC by default, not the 32 bit. And trying to define it via the JDBC entry (after defining the 32 bit ODBC entry in Windows 2008 itself), I am unable to complete because Access isn't on the list of available database formats in the dropdown box. Is there a way to use 32 bit versions of Access in a 64 bit environment? Should I install the 32 bit version of CF 9 instead? Thanks much! --Ben -- Ben Conner b...@webworldinc.com Web World, Inc. 888-206-6486 or PO Box 1122 480-704-2000 Queen Creek, AZ 85142 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:354912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm