SSRS 64bit to mandatory 32bit ODBC (Cisco UCCX)

Question

We're using 64bit SSRS on our reporting server (2008 R2). We have an ODBC connection with the 32bit IBM Informix driver connecting to Cisco UCCX. When I try to add a New Data Source in SSRS to this connection I get the below error.

"ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

Any ideas how to get around this? I think the UCCX driver needs to be 32 bit. SSRS needs to stay 64 bit for our other applications.

Answer 1

You need to use a 64-bit ODBC Driver, such as these from my employer, matching the 64-bit consumer (which is really the Microsoft OLE DB Provider for ODBC, as SQL Server isn't really an ODBC client), as these libraries will be loaded into memory together.

It doesn't matter that the target data source (the Cisco UCCX) is 32-bit, because these communications are over TCP/IP, which allows for such differences.

Answer 2

In order to use a 32 bit ODBC driver on a 64 bit Windows machine, it has to be configured using a 32 bit ODBC Administrator which is not visible through normal Windows menu options. Utilities for 32 bit operations are found in the C:\Windows\SysWOW64 directory. As a prerequisite for a 32 bit IBM Informix CSDK installation to proceed correctly, add the SysWOW64 directory to the system path, as follows:

Run 'C:\Windows\System32\control.exe system' Select Advanced system settings from Control Panel Home On the System Properties Panel that appears, Select: Advanced tab->Environment Variables In the System Variables window under Environment Variables, Select and edit the PATH variable. Prefix the PATH list with 'C:\Windows\SysWOW64;' Proceed with the IBM Informix CSDK product installation. The suggested install directory for 32 bit CSDK is 'C:\Program Files (x86)\IBM Informix Client SDK'. Once the CSDK installation is completed, access the ODBC administrator utility located at 'C:\Windows\SysWOW64\odbcad32.exe'.

Now, when you access the Drivers Tab of the ODBC Administrator, the IBM Informix Driver is visible. This is the one you want to use.