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
