ODBC from Windows to Oracle 7 on UNIX

From: Jonathan Kim <jonathan_at_apalogistics.com>
Date: Fri, 15 May 2009 09:44:04 -0700 (PDT)
Message-ID: <896f630f-ecce-4ae2-a8c0-3b63cfde0300_at_x6g2000vbg.googlegroups.com>

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 =
      (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

Original text of this message