ODBC connection questions, part 2

From: J <NOmail_at_nowhere.com>
Date: Wed, 24 Feb 1999 05:02:20 GMT
Message-ID: <36d3873a.16216457@news3.ibm.net>

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?  

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?

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?

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?


          (Host = 100.100.98.1)


          (Port = 2000)		<-I also tried 1521.  What is correct?


        )

    )
    (CONNECT_DATA = (SID = oracle7)
    )
  )

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

'ps -ef|grep ora' returns:
oraclesid1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) /usr/opt/ice/bin/ssporatcp 2000  

Any help is greatly appreciated,
-jc Received on Tue Feb 23 1999 - 23:02:20 CST