Re: ODBC from Windows to Oracle 7 on UNIX
From: ddf <oratune_at_msn.com>
Date: Fri, 15 May 2009 10:15:56 -0700 (PDT)
Message-ID: <6d1d7153-c70e-4afd-a097-86409b0a4dfc_at_h23g2000vbc.googlegroups.com>
On May 15, 11:44 am, Jonathan Kim <jonat..._at_apalogistics.com> wrote:
> 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
Date: Fri, 15 May 2009 10:15:56 -0700 (PDT)
Message-ID: <6d1d7153-c70e-4afd-a097-86409b0a4dfc_at_h23g2000vbc.googlegroups.com>
On May 15, 11:44 am, Jonathan Kim <jonat..._at_apalogistics.com> wrote:
> 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
Another thought is you could trace the client connection to the server by editing the sqlnet.ora file on the client and adding
TRACE_LEVEL_CLIENT=8 and trying the connection again. Also, on the UNIX server, there should be a listener.log file in $ORACLE_HOME/network/log you could look at to see if a valid connection was attempted at the time of the test (my guess is you'll find a valid entry).
David Fitzjarrell Received on Fri May 15 2009 - 12:15:56 CDT