Re: I do not want to use TNSNAMES.ORA. How ?

Ian C. Sellers wrote:
>
> ODBC requires sql*net! Good luck.
>
> The application/driver architecture is:
>
> Application
> |
> ODBC Driver manager
> (ODBC.DLL)
> |
> Oracle7 Driver
> (SQORA71.DLL)
> |
> OCI layer
> (ORA71WIN.DLL)
> |
> SQL*Net Driver
> |
> Network Software
> ( PCTCP, Novell Netware, Microsoft LAN Manager, etc,.)
> |
> SQL*Net Listener
> |
> Oracle7 RDBMS
>
> Joseph S. Testa wrote:
>
> > Oron Vexler wrote:
> >
> > > Hi,
> > > Is there a way I can connect to a remote database without using alias name
> > > -
> > > I mean specify the exact location of the database.
> >
> > Not if you plan on using sql*net on the client side, i guess you could use
> > ODBC instead.
> > --
> > Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
> > (home)
> > Vice-President Ohio Oracle Users Group,
> > See the Oracle FAQ at http://www.orafaq.org
> > Try http://web.scioto.net/jtesta that is also the place to find the FREE, drop
> > column script
> > ICQ UIN: 2832230(&oracle, home).

Oracle (I think) has a host naming adapter where the connect string is basically like old sqlnet v1 string where you nominate the host/sid etc etc...

I think it comes in SQLNet under Oracle8

-- 
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."