Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC connection questions

Re: ODBC connection questions

From: Guus van de Sande <gs.dyntas.nospam_at_wxs.nl>
Date: 21 Feb 1999 13:14:31 GMT
Message-ID: <01be5d9b$ee2886e0$c04e79c3@tulip-dt>


Hi,

You should take the following steps, to connect your NT-workstation to the Oracle Server.

  1. Install SQL Net V2 on your UNIX-server
    • load and link the software
    • create a file LISTENER.ORA in the directory $TNS_ADMIN examples are in this directory
  2. Install the SQL Net client software on your NT-workstation (software resides on the Oracle 7.3.2 Client for Windows CD)
    • create a file TNSNAMES.ORA in the directory C:\ORANT\NETWORK\ADMIN (or in the directory where the registry key TNS_ADMIN to points
    • In the file TNSNAMES.ORA you place an entry <database>.WORLD, giving the parameters for the name of the UNIX-server (or IP-adress) and the IP - port.
    • check if the server is responding via: TNSPING <database>
  3. Install the ODBC-software on your workstation. Connect your server via <username>, <password>, <database>

Hope this will give you an idea.

gr,
Guus Received on Sun Feb 21 1999 - 07:14:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US