ODBC from Windows to Oracle 7 on UNIX
Date: Fri, 15 May 2009 09:44:04 -0700 (PDT)
Message-ID: <896f630f-ecce-4ae2-a8c0-3b63cfde0300_at_x6g2000vbg.googlegroups.com>
Hi,
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
client.
However, I am having trouble to connecting the client to the Oracle
server on UNIX.
Below is what I have in tnsnames.ora
CMS7 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apa.apa-intl.com)(PORT =
1521))
)
(CONNECT_DATA =
(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