Microsoft Access Windows 2008 64 Bit CFMX 9 64 Bit

[a.s.webster]

We are migrating from CFMX 7 on a 32 bit Windows server to Windows 2008 64 bit with CFMX 9 standard 64 bit edition.  When attempting to add Microsoft Access datasources, I received the Unable to update the NT registry. Variable DRIVERPATH is undefined error.  I search the net and tried the recommended solutions I came across including installing Microsoft Office 2010 64 bit.  None of the solutions have worked.  I eventually came across the error "architecture mismatch between the driver and application" when trying some of the different solutions.

Most, if not all, of the recommendations I found online were dealing with Windows 7 or Vista, not server operating systems though.

This is a shared hosting server for our clients and some of them have older web sites implemented in Access and are reluctant to switch to SQL server because of the size and scope of their databases and it is really us who wish to migrate them in order to move to newer hardware and decommission the older server(s).

Has anyone successfully defined Access datasources within CFMX 64 bit on a server operating system and if so, how?  Thanks in advance!

[ilssac]

a.s.webster wrote:

Has anyone successfully defined Access datasources within CFMX 64 bit on a server operating system and if so, how?  Thanks in advance!

Not that I am aware of, since as far as I know, Microsoft has not made a 64 bit driver for their Access product.  With out a driver it is rather difficult to connect to the database.

If you wish to support these sites without an update to the database, you may be required to run a 32 bit system in some environment.

[a.s.webster]

Does anyone know if CFMX 32 bit can be installed on Windows 2008 64 bit?  This would allow us to take advantage of those 64 bit resources and increased memory for those applications running as such and then accommodate the 32 bit limitation though CFMX and Access.

[ilssac]

I beleive that yes you can install 32 bit ColdFusion on a 64 bit system.  The troulbe is that you also need a 32 bit JVM and a 32 bit IIS.

As I understand it, with IE 7 you can mix and match 32 bit and 64 bit, but in IE 6 it has to be all one or the other.

I have read discussions on the hows and whys and the ins and outs of installing 32 bit CF on 64 bit systems.

What I do not recall is if you can install both 32 bit and 64 bit CF on a single machine.  You may be able to with a multi-home or J2EE configuration of CF enterprise.

[JR__Bob__Dobbs-qSBHQ2]

You might try to find a third party JDBC driver for access.

http://developers.sun.com/product/jdbc/drivers

Connecting to an external JDBC Type 4 data source
http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe7.html

[a.s.webster]

Just FYI,

I searched the site for a JDBC driver and the only result that had a working web address cost nearly 1k.

I uninstalled CFMX 64 bit and installed the 32 bit version.  Changed the default application pool to run 32 bit applications and the connection to Access worked perfectly.