Re: 16-bit Oracle (SQL*Net) and Win98

Yes.

I have managed to get SQL Net 2 working under Windows 98, although it took some time to do (basically I had trouble finding the correct installation disks).

The first thing to do is to be able to Ping your target machine from DOS. We have a Unix box running the Oracle database. This is to check that the network connection works.

Using an Oracle Products for Windows installation CD for Oracle 7.0, I installed the Oracle TCP/IP Adapter v2.0.15.0.4, when it asks for the vendor software that I was using, I chose: Microsoft Windows NT via Winsock.

Next was the SQLNet v.2.0.15.0.3 installation, again off the same CD.

Next I installed the Network Manager v2.1.3.0.0A from the same CD. Once installed, leave the installation software, and run the Network Manager. This software is tricky to understand, and you may need the documentation (it comes with the Oracle TCP/IP adapter package). Basically this sets up the TNSNAMES.ORA, and SQLNET.ORA files.

I then finally installed SQL Plus 3.1.2.2.6 to test the connection, and it worked (eventually).

The key configuration file to the whole thing - as far as I can tell - is the TNSNAMES.ORA file and the use of the Network Manager.

My only problem now is accessing the database through an Access 2 database using ODBC.

Anthony Nicholls
Computer Programmer
Stourbridge College
e-mail: am.nicholls_at_cableinet.co.uk

Amy A. Miller wrote:

> Hi--
>
> Has anyone had an experience successfully installing and running SQL*Net
> 2 (the 16-bit) under Win98? We still need to support some 16-bit users,
> but I've upgraded my machine and am having problems installing....
>
> Thanks,
> Amy Miller
>
> --
> ====================================
> Amy A. Miller, Data Analyst
> University of Pennsylvania ISC
> Office of Data Administration
> 3401 Walnut, Suite 265C /6228
> Philadelphia, PA 19104-6228
> Phone: 215-898-2171 Fax:215-898-0386
> Email: milleraa_at_isc.upenn.edu
Received on Tue Feb 23 1999 - 04:53:52 CST