Home > Oracle Database, Oracle MiddleWare > ODBC Connection Issues – Architecture Mismatch Issue

ODBC Connection Issues – Architecture Mismatch Issue


Issue “[MICROSOFT] [ODBC Driver Manager] The specified DSN contains an architecture mismatch between driver & applications”

This is a typical issue you find in Windows 64 bit OS that tries to use 32 bit Oracle drivers while configuring ODBC connection.

There are 4 ways to solve this issue:

Scenario 1:

  • On Windows 64 bit OS
  • If Oracle Database Server with 64 bit already installed
  • If ArcGIS Server 32 bit is already installed
  • Install Oracle Client 32 bit 
  • Go to C:\windows\SysWOW and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.

Scenario 2:

  • On Windows 64 bit OS
  • If Oracle Database Server with 64 bit already installed
  • If ArcGIS Server 64 bit is already installed
  • Go to c:\windows\system32 and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.

Scenario 3:

  • On Windows 64 bit OS
  • If Oracle Database Server with 32 bit already installed
  • If ArcGIS Server 32 bit is already installed
  • Go to c:\windows\SysWOW and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.

Scenario 4:

  • On Windows 32 bit OS
  • Install 32 bit Oracle client to connect to remote database server
  • Go to c:\windows\SysWOW and search for odbcad.exe
  • Run odbcad.exe to add ODBC connection (just google for creating ODBC connection)
  • Go to ArcCatalog, create an OLEDB connection. From the drop down chose ODBC connection name you created in above step.
Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: