1705121 - Error message "IM014: [Microsoft] ODBC Driver Manager] The specified DSN contains an architecture mismatch between the driver and the application"

SAP Knowledge Base Article - Public

1705121 - Error message "IM014: [Microsoft] ODBC Driver Manager] The specified DSN contains an architecture mismatch between the driver and the application"

Symptom

  • Failed to logon to Oracle Database in Crystal Reports for .NET application
  • Error message: IM014: [Microsoft] ODBC Driver Manager] The specified DSN contains an architecture mismatch between the driver and the application

Environment

  • SAP Crystal Reports for Visual Studio 2010
  • Microsoft Visual Studio 2010
  • Oracle11g (64bit) Database
  • ODBC 64bit

 

Reproducing the Issue

  1. Launch Microsoft Visual Studio 2010 on 64bit Windows platform.
  2. Click File > Open Project.
  3. Select project file(Crystal Reports for .NET application with Oracle ODBC connection) which is created on 32bit Windows platform and click Open.
  4. Click Debug > Start Debugging.

 

 

Resolution

  1. Install 32bit Oracle client.
  2. Navigate to C:\Windows\SysWOW64 folder on the 64bit Windows platform.
  3. Run odbcad32.exe.
  4. Create a new Oracle ODBC data source name on the same machine having same ODBC data source name of a 64bit Oracle ODBC connection.

Keywords

odbc, Data Source Name, oracle, system DSN, OLEDB, OLE DB, rpt, Microsoft ODBC for Oracle, Oracle in OraClient11g_home1, TNS, TNS Service name, Microsoft ODBC for HANA , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , HAN-STD-DEV-MOD-CLT , SAP HANA Analytical Modeling - Client Component , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio