There IS an Access driver that is 64 bit. It is httx. You can also jury rig a proxy ws to a 32bit server (which is how I handled it for a data export). That approach assumes you have access to both types of server and on a shared host is probably out of the question. The 64bit driver may be out of the question as well.
Here's a post on the topic. http://www.coldfusionmuse.com/index.cfm/2009/4/7/MS.Access.Proxy The notes below have some comments on the 64 bit driver. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: John Pullam [mailto:[email protected]] Sent: Thursday, October 15, 2009 12:02 PM To: cf-talk Subject: CF8, 64 bit, and Microsoft Access I've just been told by my ISP that CF8 doesn't support Microsoft Access on a 64 bit server, and seeing as they are implementing it on a 64 bit server, I'm in trouble. Don't get me wrong--I understand that Access isn't strategic and I will be moving away from it, but I have an app that gets an Access mdb and must process it and I really need to move up to CF8 to start adding Ajax features. Is it true? And if yes, is there anything I can do? Are there technical alternatives to allow me to use Access from a 64 bit CF8 system? I looked at the brief CF9 doc on the Adobe site and it implied that Access is fully supported. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
