32-bit drivers not seen in 64-bit CF Administrator config?

Report · Jan 08, 2010

We're migrating from 32 bit CF8 to

64 bit CF9. One of our legacy ODBC datasources, an HP Mini, is accessed via a Minisoft driver which only comes in 32 bit.

The driver is configured in Windows control panel fine, via the Windows wow64.exe add-in. When we try to configure it in the CF Administrator as a datasource, it's not visible.

Is there some workaround, some way to make it show up?

Thanks,

VB

Report · Feb 04, 2010

Hi there

I am not sure if you have resolved your issue or not, but I have had the exact same problem coming from 32bit to 64bit coldfusion. My problem was I needed to connect to excel and access. Microsoft unfortunately does not have any 64bit drivers for these products. Much to the dismay of quite a few people I discovered.

You will need 64bit datasource drivers. If you can't get drivers then you will have to switch to the 32bit version of coldfusion.

Another option is to think of perhaps a work around. For instance I heard of people connecting to access databases through sql server. So using the 64bit sql server driver, to connect to a 32bit sql server instance, connecting to access using the 32bit driver.

Hope this helps.

Cheers