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