Hi, Thanks in advance!
Database: oracle 9i sitting on a 32 bit machine.
Client: windows7 64 bit computer
installed oracle 11gr2 client
Is there a way to connect to oracle 9i database from C:\Windows\SysWow64\odbcad32.exe on windows 7 machine? or what is the possible way to connect to Oracle 9i database?
What we need is to run crystal reports from windows 7.
Again, thanks and happy holiday!
Edited by: user11017933 on Dec 20, 2012 12:17 PM
If you installed a 32 bit Oracle client, the ODBC connection should appear in there and everything should work.
If you installed a 64 bit Oracle client, you'd have to use the 64 bit ODBC administrator (the one in Control Panel), and only 64 bit applications could use it.
Thanks for your reply!
Yes, I installed 11gr2 32 bit client as administrator, but still not work.
When I run odbcad32.exe located in C:\Windows\SysWOW64, a new System DSN can be added using OracleClientHome, but connection does not work. Do I miss anything?
The error message is:
Unable to connect
[ORACLE][ODBC][Ora]ORA-12154:TNS: could not resolve the connect identifier specified
Edited by: user11017933 on Dec 21, 2012 4:56 AM