Re: ODBC connection questions, part 2

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

On Wed, 24 Feb 1999 05:02:20 GMT, NOmail_at_nowhere.com (J) wrote:

>This is a follow up from my attempts to make an
>OBDC connection to Oracle7 Server Release 7.2.3.0.0
>
>I installed SQLNet 2.2 from the Oracle Products for
>Windows CD. But I found no hint of ODBC drivers on this
>CD. Where can I find them?

They were not provided by Oracle at that time. They were on the web, but nowadays as O7.3 and sqlnet 2.3 is the only supported version, you won't find any drivers on their website specifically for sqlnet 2.2 Oficially sqlnet should be downwards compatible, however there is a central interface dll which has a version number in it. I'm afraid you need to upgrade your database, or a find a driver which calls orawin72.dll

>
>I already have an ODBC driver:
>Microsoft ODBC for Oracle 2.573,292700
>but when I try to set up a new data source in the
>32bit ODBC control panel, I get an error saying:
>
> 'The Oracle client and networking componets
>were not found. These components are supplied by
>Oracle Corp. and are a part of the Oracle Version
>7.3 (or greater) client software installation.
>You will be unable to use this driver until these
>components have been installed.'
>
>Perhaps this ODBC driver is too new for SQLNet 2.2?
Yes, definitely! It is searching for orawin73.dll and it doesn't find it.
>
>How can I determine the name of the Oracle server?
>"its the service name in your tnsnames.ora on the server."
>I haven't found where the tnsnames.ora is stored on the server?

in $ORACLE_HOME/network/admin

officially in the TNS_ADMIN directory, if the env var doesn't exists /etc and this directory are searched for.

>
>If I cat /etc/oratab:
>#
>#
>sid1:/usr/oracle:Y
>
>So, I created the \orant\network\admin\tnsnames.ora file:
>sid1.WORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = beq) <-I also tried TCP. What is correct?
TCP, bequeath is for access on the server only

> (Host = 100.100.98.1)
> (Port = 2000) <-I also tried 1521. What is correct?
1521 is correct and officially assigned to Oracle. 1526 has also been used in the past
> )
> )
> (CONNECT_DATA = (SID = oracle7)

(SID=sid1) as that is the sid from /etc/oratab
> )
> )
>
>tnsping>sid1.WORLD
>number of pings>3
>
>Attempting to contact
>(ADDRESS=(PROTOCOL=TCP)(Host=100.100.98.1)(Port=2000)
>TNS-12538: TNS:no such protocol adapter
This points to you don't have the sqlnet 2.2 tcp/ip protocol on your client. Otherwise you would have received a different error message (12545)
>
>'ps -ef|grep ora' returns:
>oraclesid1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
>/usr/opt/ice/bin/ssporatcp 2000
>

There should have been more processes, currently it looks like only the listener is running and with an incorrect protocol. The image name is also VERY strange
>
>Any help is greatly appreciated,
>-jc
>

Sybrand Bakker, Oracle DBA Received on Wed Feb 24 1999 - 06:40:16 CST