I work on Win 7 64 bit, Oracle SOE 11g R2 64 bit.
I am trying to integrate my DB with this program
http://goconnectcrm.com/ that is 32 bit.
I used odbcad32 and Oracle in OraDb11g_home1 driver that I suppose it is 32 bit (SQORA32.DLL)
When I tried to access the ODBC through that Go Connect program, I got this error:
The test of the connection was successful on ODBC for the user : APEX_PUBLIC_USER.
preview failed, exception: error [IM014] [Microsoft] [ODBC DRIVER Manager]
The specified DSN contains an architecture mismatch between the driver and application
So, Go Connect is not able to see my DB... Any help please ??
I experience the same after doing some analysis it worked plz find below scenario details. Scenario:_ below were installed on same Machine 64bit
DB Instance: *64bit*
software (KXEN) to integrate: *32 bit* Error:_
Message from ODBC: Connection failed: [IM014][Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application Workout:_
Install 32 bit Oracle client on 64 bit machine which will change the pointer to latest installed 32bit -> SQORA32.DLL
Make sure that you create your ODBC link using the 32 bits ODBC Manager: