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: How to connect to different database in Oracle 7 ?

Re: How to connect to different database in Oracle 7 ?

From: Konstantin Kivi <konst_at_sirena.rinet.ru>
Date: Thu, 23 Apr 1998 08:22:12 GMT
Message-ID: <Eruxx0.22G.0.debian@sirena.rinet.ru>


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

Original text of this message

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