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
- Launch Microsoft Visual Studio 2010 on 64bit Windows platform.
- Click File > Open Project.
- Select project file(Crystal Reports for .NET application with Oracle ODBC connection) which is created on 32bit Windows platform and click Open.
- Click Debug > Start Debugging.
Resolution
- Install 32bit Oracle client.
- Navigate to C:\Windows\SysWOW64 folder on the 64bit Windows platform.
- Run odbcad32.exe.
- 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 , Problem
Product
SAP Crystal Reports, developer version for Microsoft Visual Studio