Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to connect to different database in Oracle 7 ?
Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk> wrote:
> Look at the CONNECT (embedded) statement syntax in the Pro*C (or any other
> Oracle percompiler manual, or the SQL Reference manual). Basically, you
> stick the database SID on the connect string. You can also use this syntax
> if you wish to simultaneously connect to multiple servers from within the
> one program.
A you sure this is true? You have to add SqlNet name like @db_name after user/password (listener must be set up). You method didn't work for me.
> Steve Phelan.
--
Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru
aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org Received on Thu Apr 23 1998 - 03:22:12 CDT