AnsweredAssumed Answered

SQLDriverConnect [C] [IM014]: The specified DSN contains an architecture mismatch between the Driver and Application

Question asked by RayHoward on Aug 16, 2016
Latest reply on Mar 14, 2017 by FionnMurray

Hi,

I'm trying to setup the RDBMS connection via ICU and get a SQLDriverConnect error showing a architecture mismatch.

 

Versions I'm using are:

RDBMSPI.exe -  3.22.13.144

Uniint - 4.6.1.5

From the ICU rdbodbc menu - Relational Database Interface-Specific Parameters (3.21.5.44)

SQL Server (32 bit) - 6.03.9600.17415 (SQLSRV32.dll 22/11/2014)

Windows Server 2012 R2 Version 6.3 (Build 9600)

 

I have created the rdbms connection to a SQL Server on a standalone interface server. The rdbms installed fine and runs and it tells me it is installed. The ODBC connection Tests OK from the 32bit ODBC manager to the SQL server.

 

Reading the PI Message log I get the message:

>> SQLDriverConnect [C] [IM014]: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

>> Unsuccessful connection to ODBC_DSN. Keep trying.

 

Next it gets the password from the *.pwd file from PIPC\etc\etc and then promptly fails and repeats itself for ever.

Doing a Google on this basically tells me that I have a mismatch between 32bit and 64bit, which I know I don't.

 

A suggestion from one link (from IBM) suggests this to fix it:

 

Resolving the problem

To resolve the problem, one needs to compile the application within Visual Studio targeted for an 'x86' CPU. This will ensure that the application attempts to load the 32-bit ODBC provider instead of the 64-bit one. You can do this by right clicking on your project and selecting Properties. In the build tab, you will find the Platform Target (ANY CPU, x86, x64 or Itanium).

 

Not sure that is going to happen ;-)

In my test environment I was using:

RDBMSPI.exe -  3.21.4.30

Uniint - 4.5.5.22

From the ICU rdbodbc menu - Relational Database Interface-Specific Parameters (3.21.5.44)

SQL Server (32 bit) - 6.03.9600.17415 (SQLSRV32.dll 22/11/2014)

Windows Server 2012 R2 Version 6.3 (Build 9600)

 

And that all worked fine. Has something changed in the update?

 

Any ideas how to fix it?

 

Many thanks,

 

Ray

Outcomes