ODBC from Windows to Oracle 7 on UNIX
Date: Fri, 15 May 2009 09:44:04 -0700 (PDT)
I am very new with Oracle.
This company has Oracle 7 on UNIX and I want to establish ODBC from Windows.
The vendor who set up this system made themselves pretty clear that they don't want to help us set up ODBC.
So, I need your help.
One scenario I found was installing Oracle 8i client on Windows and
connecting it to Oracle 7 on UNIX. Then set up ODBC to Oracle via the
However, I am having trouble to connecting the client to the Oracle server on UNIX.
Below is what I have in tnsnames.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = apa.apa-intl.com)(PORT = 1521))
(SID = cms7)
“apa.apa-intl.com” is hostname of UNIX machine and cms7 is SID of our
production db on UNIX.
I made sure on internal DNS that “apa.apa-intl.com” points to the UNIX machine.
Still, “test service” fails to connect to the server as below.
>Initializing first test to use userid: scott, password: tiger
>Attempting to connect using userid: scott
>The test did not succeed.
>ORA-01017: invalid username/password; logon denied
>There may be an error in the fields entered,
>or the server may not be ready for a connection.
It still happens with legitimate login id and password.
Thank you for your help in advance.
Jonathan Kim Received on Fri May 15 2009 - 11:44:04 CDT