Re: ODBC with Personal Oracle 7.3 ?

From: MSHANKR <mshankr_at_aol.com>
Date: 15 May 1999 01:45:11 GMT
Message-ID: <19990514214511.11102.00000786@ng-fr1.aol.com>

Well,

Sorry, this got sent by mistake:

1. ODBC connect string will point to the Alias of the Sql*Net.(which is configured in tnsnames files)
2. Sql*Net will contain particulars of connect string that is : Host, Port,Protocol and SID. and named alias in tnsnames file.

3)Your TNS Listener must be up and running for ODBC to succeed connection.

4)With Listener working and the alias setup in the Tnsnames file. you will configure ODBC using an Oracle driver and giving a DSN name.

So,example

DSN: Oracle
pick driver as oracle,
Server: (Alias) PO7

Tnsnames file:

PO7.world= identify that you set the following

     Host= your computer name
     SID=your instance name which defaults to ORCL or whatever

 Port= default should be good enough
Protocol=tcp

This should work,

If you have problems, let me know
I can you send you sample files to configure

Thanks

Manu Shankar

mshankar_at_exchange.ml.com Received on Fri May 14 1999 - 20:45:11 CDT