ColdFusion 8, 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.

If it's shared hosting, then you're probably out of luck because you are at their mercy.  If you have a virtual server, however, then maybe you can try installing the access 32 bit odbc driver on your 64 bit system, and then use it through the ODBC Socket driver in ColdFusion.....it's worth a try... Dave 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.

On Thu, Oct 15, 2009 at 1:01 PM, John Pullam <jpullam@mcleansystems.com> wrote: > > 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? Move your site to a server that doesn't run 64 bit CF Or maybe hire a .NET programmer to write on object you can use to do the work using .NET integration (probably not an option if you're on shared hosting). Rick

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 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.