Board index » delphi » Oracle 8i connection without TNSnames.ora?

Brian Santarelli

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Oracle 8i connection without TNSnames.ora?

Does anybody know of a way to pass SQLLinks a connect string that specifies
the server IP address, instance name, etc. in order to connect to an Oracle
8i server without a TNSNames.ora? (Host naming is not an option for us)
Also, does anybody know why Net8 will not accept the IP address for a TCP/IP
connection as the host name?  SQL-Net 2.3 would allow you to do this.
Thanks in advance for any help.
 
Dmitry Arefie

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle 8i connection without TNSnames.ora?


Quote
Brian Santarelli wrote:

> Does anybody know of a way to pass SQLLinks a connect string that specifies
> the server IP address, instance name, etc. in order to connect to an Oracle
> 8i server without a TNSNames.ora? (Host naming is not an option for us)

I not test it. But in general, where You can use alias from
TNSNames.ora,
You can, also, use service descriptor (right parts in TNSNames.ora).

Quote
> Also, does anybody know why Net8 will not accept the IP address for a TCP/IP
> connection as the host name?  SQL-Net 2.3 would allow you to do this.

It is wrong. You can pass IP address as host name. Seems, that You have
other issues.

Dmitry

--
------------------------------------------------------------------------
Dmitry L. Arefiev, senior programmer, Nica-Com ltd.
Author of NCOCI8 - Delphi to Oracle8i direct access
EMail: di...@ncom.ru      ICQ: 50741007

Other Threads

1. Oracle tnsnames.ora file update

2. Oracle 8i ORA-01410 invalid ROWID error

3. Oracle 8i ORA-01410 invalid ROWID error

4. ORA-01041 error with Oracle 8i and Windows 98

5. Oracle 8i Personal Edition and ORA-01410 ROWID Error

6. Oracle 8i : ORA-01041

7. Oracle 8i and BDE5.01: ORA-01041: internal error, hostdef extension doesn't exist

8. creating an ADO connection to Oracle 8i at runtime

9. Oracle 8i and ADO connection question

10. no connection from BDE 5.01 to Oracle-8i-Client (Using Windows 2000)