Re: Connecting Form To Multiple Servers

From: Loyal Barber <lbarber_at_nospam.flash.net>
Date: Thu, 25 Mar 1999 20:00:07 GMT
Message-ID: <36FA95BF.6C9FD0C4@nospam.flash.net>

By default you are correct. However, if you are using Forms 5 you can use the exec_sql.pll package found at ORACLE_HOME/oca20/plsqllib to manage multiple connections.

Loyal Barber
BLT Soft Incorporated

Kevin Miller wrote:

> We will be (over the next few years) migrating production applications from
> a UniData - Unibasic (PIC) environment on a Unix server to Oracle on a Unix
> server. I am able to create a Developer 2K form which can access data on the
> UniData server and I can create a Developer 2K form (obviously) which can
> access the new Oralce server but I don't seem to be able to create one
> Developer 2K form which can access both servers at the same time. I am able
> to do this using MS Visual Basic 6.x however.
> It seems that Developer 2K needs to log off one server and then log onto the
> second sever. Is there a way to have two (or more) concurrent connections to
> different servers?
> Thanks,
> KM
Received on Thu Mar 25 1999 - 14:00:07 CST