Unable to Connect, ORA 12154, Setup routine for Microsoft ODBC errors
602594Feb 26 2013 — edited Feb 28 2013Hi all,
I have a Windows 7 Enterprise 64bit SP1 system and I wanted to be able to connect to an oracle database server. However, I am facing a problem with ODBC configuration.
I have currently installed both below in ... product\11.2.0\client_1 folder:
1. Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) - http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
2. 64-bit Oracle Data Access Components (ODAC) - http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
I launched ODBC Data Source Administrator and added a User DSN but resulted to two errors:
1. The setup routines for the Microsoft ODBC for oracle ODBC driver could not be found. Please reintall the driver.
2. The specified DSN contains an architecture mismatch between the driver and application.
On top of that, if I go to System DSN tab, and tried to test the connection it give me an error:
1. Unable to connect SQLState = 08004 [Oracle][ODBC][Ora]ORA-12154: TNS: Could not resolved the identifier specified.
Can someone please guide me through this? Thanks in advance!
Edited by: VTech on Feb 26, 2013 2:13 PM