Re: 32 vs 64 bit CF and DSNs
I finally pulled the plug on the 64 but and installed the 32 bit CF version. I'm also using CF 32bit, but it is because of some 32bit CFXs, but I did have the 64bit running with Access datasources. I have Access 2003 installed on the server, may be you need it to bring the correct 32bit drivers. ~| 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:354942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 32 vs 64 bit CF and DSNs
Tried that and it was still an issue; Couldn't see any dsn's defined through the odbcad32 applet, and when I tried to point to it via a jdbc entry, the only databases listed in the dropdown list were Dbase x varieties. I finally pulled the plug on the 64 but and installed the 32 bit CF version. Problem solved. --Ben On 3/9/2013 7:06 PM, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote: You cannot natively run msaccess on 64bit windows as there is no 64bit jet driver, Actually you can. Look for C:\Windows\SysWOW64\odbcad32.exe This is a 32bit ODBC Data source Administrator. Use it to define your System DSN first, then in the CF Administrator define your datasource with the Microsoft driver on that ODBC DSN. I have CF 9 32bit installed, because of some legacy CFX compiled in 32bit, and it works well. It might be slightly different with CF 64bits, then have a look here: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess ~| 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:354931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 32 vs 64 bit CF and DSNs
what you have suggested is a work around using 32bit, not native 64 bit. As I did mention there are work arounds , but they will not allow a CF DSN to just be setup in the CFADMIN with no other work, including your suggestion above, they require extra steps. I have yet to find a perfect solution that allows CF DSN's for MSACCESS to work with no other manual steps. If you know otherwise, please do share/ You find more info here. http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6 On Sun, Mar 10, 2013 at 2:06 AM, wrote: You cannot natively run msaccess on 64bit windows as there is no 64bit jet driver, Actually you can. Look for C:\Windows\SysWOW64\odbcad32.exe This is a 32bit ODBC Data source Administrator. Use it to define your System DSN first, then in the CF Administrator define your datasource with the Microsoft driver on that ODBC DSN. I have CF 9 32bit installed, because of some legacy CFX compiled in 32bit, and it works well. It might be slightly different with CF 64bits, then have a look here: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess ~| 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:354918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
32 vs 64 bit CF and DSNs
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
Re: 32 vs 64 bit CF and DSNs
Don't have an example handy cuz I don't use Access, but what about using dbtype 'Other' and manually specifying the strings? the way we used to have to do when mySQL support was dropped a few years back? 64-bit CF vs. 32-bit is so much more capable I'd do whatever it takes to NOT go back to 32-bit if I were you. p.s. notice how I didn't say anything snotty about using Access? :-) -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:354913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 32 vs 64 bit CF and DSNs
Funny you should mention that. These are production client databases and I am not really authorized to 'fix' them, but I'm installing the 64 bit vsn of Access now and seeing if I can update them to 64 bit after I finish the install. Just as soon make them all SQL 12, but that isn't my call. --Ben On 3/9/2013 3:22 PM, Money Pit wrote: Don't have an example handy cuz I don't use Access, but what about using dbtype 'Other' and manually specifying the strings? the way we used to have to do when mySQL support was dropped a few years back? 64-bit CF vs. 32-bit is so much more capable I'd do whatever it takes to NOT go back to 32-bit if I were you. p.s. notice how I didn't say anything snotty about using Access? :-) -- 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:354914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 32 vs 64 bit CF and DSNs
You cannot natively run msaccess on 64bit windows as there is no 64bit jet driver, it is now legacy and Microsoft no longer support it. There is also no longer any 32bit version of windows since 2008 r2, its all 64bit now. If you seatch on Google there is a work around to get it to work with the old 32bit jet driver. I have not found any way to have this work automatically so you can just setup the dsn in cfadmin and it works. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Mar 9, 2013 11:25 PM, Ben Conner b...@webworldinc.com wrote: Funny you should mention that. These are production client databases and I am not really authorized to 'fix' them, but I'm installing the 64 bit vsn of Access now and seeing if I can update them to 64 bit after I finish the install. Just as soon make them all SQL 12, but that isn't my call. --Ben On 3/9/2013 3:22 PM, Money Pit wrote: Don't have an example handy cuz I don't use Access, but what about using dbtype 'Other' and manually specifying the strings? the way we used to have to do when mySQL support was dropped a few years back? 64-bit CF vs. 32-bit is so much more capable I'd do whatever it takes to NOT go back to 32-bit if I were you. p.s. notice how I didn't say anything snotty about using Access? :-) -- 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:354915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 32 vs 64 bit CF and DSNs
You cannot natively run msaccess on 64bit windows as there is no 64bit jet driver, Actually you can. Look for C:\Windows\SysWOW64\odbcad32.exe This is a 32bit ODBC Data source Administrator. Use it to define your System DSN first, then in the CF Administrator define your datasource with the Microsoft driver on that ODBC DSN. I have CF 9 32bit installed, because of some legacy CFX compiled in 32bit, and it works well. It might be slightly different with CF 64bits, then have a look here: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess ~| 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:354916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 32 vs 64 bit CF and DSNs
Also you may want to do a search on the Microsoft ACE drivers. They came up with them for accessing office 2010. I'm almost positive they are 64 bit drivers. Sent from my iPhone On Mar 9, 2013, at 9:06 PM, Claude Schnéegans schneeg...@internetique.com wrote: You cannot natively run msaccess on 64bit windows as there is no 64bit jet driver, Actually you can. Look for C:\Windows\SysWOW64\odbcad32.exe This is a 32bit ODBC Data source Administrator. Use it to define your System DSN first, then in the CF Administrator define your datasource with the Microsoft driver on that ODBC DSN. I have CF 9 32bit installed, because of some legacy CFX compiled in 32bit, and it works well. It might be slightly different with CF 64bits, then have a look here: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess ~| 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:354917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm