Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
I have a post on this... http://www.coldfusionmuse.com/index.cfm/2009/4/7/MS.Access.Proxy Note the comments - there is an acceptable 64bit commercial driver that does not cost an arm and a leg. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com 7 Hello Dave, Any solution for the following: Windows 7 ColdFuison 9 64 bit - How to connect to MS access 2003 DB? (I saw the solution for 32 bit CF on windows 7) NOTE: as per Paul Kukiel, --- Pretty sure access dosn't work in 64bit ColdFusion 8 or 9 -- Is this is still true or is there a solution? Appreciate your help Girumala ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
Mark, I saw the JDBC driver from http://www.hxtt.com and i am going to download and try. Secondly what about ColdFusion 9 on windows 7 connectivity to MS Access 2010? Any readily available drivers or do we need to buy? Any thoughts on this? Appreciate your help Girumala ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
I am successfully using the HXTT driver on a 64 bit platform for that purpose. The only glitch I have run into is that the queries were all case sensitive. They do have a parameter you can set to turn that off. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
Hello Dave, Any solution for the following: Windows 7 ColdFuison 9 64 bit - How to connect to MS access 2003 DB? (I saw the solution for 32 bit CF on windows 7) NOTE: as per Paul Kukiel, --- Pretty sure access dosn't work in 64bit ColdFusion 8 or 9 -- Is this is still true or is there a solution? Appreciate your help Girumala ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
I have a post on this... http://www.coldfusionmuse.com/index.cfm/2009/4/7/MS.Access.Proxy Note the comments - there is an acceptable 64bit commercial driver that does not cost an arm and a leg. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: girum...@yahoo.com girum...@yahoo.com [mailto:girum...@yahoo.com] Sent: Monday, July 19, 2010 1:50 PM To: cf-talk Subject: Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7 Hello Dave, Any solution for the following: Windows 7 ColdFuison 9 64 bit - How to connect to MS access 2003 DB? (I saw the solution for 32 bit CF on windows 7) NOTE: as per Paul Kukiel, --- Pretty sure access dosn't work in 64bit ColdFusion 8 or 9 -- Is this is still true or is there a solution? Appreciate your help Girumala ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
Thanks. That solved the problem. I installed the 32-bit version of ColdFusion 8, then set Enable 32-bit Applications to True for the Application Pool in IIS. Bob Mack I'm having trouble creating Access Data Sources in ColdFusion 9 (same issue with CF8) on a 64 bit Windows 7 box. Two questions: 1) Does anyone know when a 64 bit version of ColdFusion 9 will be released that is compatible with Windows 7? The current version is compatible with Windows 7. 2) Does anyone have a workaround for this issue, apart from installing ColdFusion on the XP Virtual PC? If you want to use 32-bit stuff, use the 32-bit version of CF. It'll work fine on a 64-bit OS. There will be some issues if you want to hook it to IIS, but those issues are documented and pretty easy to fix. On the other hand, maybe this is the divine hand of Providence pushing you away from Access and towards, well, anything else. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
I'm having trouble creating Access Data Sources in ColdFusion 9 (same issue with CF8) on a 64 bit Windows 7 box. Two questions: 1) Does anyone know when a 64 bit version of ColdFusion 9 will be released that is compatible with Windows 7? 2) Does anyone have a workaround for this issue, apart from installing ColdFusion on the XP Virtual PC? The specific errors are: When I create the Data Source in ColdFusion I get Unable to update the NT registry. Variable DRIVERPATH is undefined. When I try to use the Data Source I get Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application There apparently is no 64 bit Access ODBC driver but I can get to the 32 bit drivers at C:\Windows\SysWOW64\odbcad32.exe. Setting up the Access DSN there first, or replacing it after the Data Source is created in ColdFusion does not solve the problem. Thanks for any help you can offer. Bob Mack cantabr...@comcast.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
1) I have been running CF9 an Windows 7 sine the Beta without issue for months. 2) Pretty sure access dosn't work in 64bit ColdFusion 8 or 9 Paul. On Nov 15, 2009, at 7:16 PM, Robert Mack wrote: I'm having trouble creating Access Data Sources in ColdFusion 9 (same issue with CF8) on a 64 bit Windows 7 box. Two questions: 1) Does anyone know when a 64 bit version of ColdFusion 9 will be released that is compatible with Windows 7? 2) Does anyone have a workaround for this issue, apart from installing ColdFusion on the XP Virtual PC? The specific errors are: When I create the Data Source in ColdFusion I get Unable to update the NT registry. Variable DRIVERPATH is undefined. When I try to use the Data Source I get Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application There apparently is no 64 bit Access ODBC driver but I can get to the 32 bit drivers at C:\Windows\SysWOW64\odbcad32.exe. Setting up the Access DSN there first, or replacing it after the Data Source is created in ColdFusion does not solve the problem. Thanks for any help you can offer. Bob Mack cantabr...@comcast.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Access Data Source Problem with ColdFusion 9 on 64 bit Windows 7
I'm having trouble creating Access Data Sources in ColdFusion 9 (same issue with CF8) on a 64 bit Windows 7 box. Two questions: 1) Does anyone know when a 64 bit version of ColdFusion 9 will be released that is compatible with Windows 7? The current version is compatible with Windows 7. 2) Does anyone have a workaround for this issue, apart from installing ColdFusion on the XP Virtual PC? If you want to use 32-bit stuff, use the 32-bit version of CF. It'll work fine on a 64-bit OS. There will be some issues if you want to hook it to IIS, but those issues are documented and pretty easy to fix. On the other hand, maybe this is the divine hand of Providence pushing you away from Access and towards, well, anything else. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
