Re: PRO C for two database

abhi147_at_gmail.com wrote:
> Sybrand Bakker wrote:
> > On 31 Aug 2006 22:23:06 -0700, abhi147_at_gmail.com wrote:
> >
> > >Hi ,
> > >
> > > I need to connect to two databases(Oracle 8.0.5 and 10g) . What
> > >should be the $ORACLE_HOME for such a case ?
> > >
> > >Thanks!
> >
> > AFAIK it's not going to work, because 8.0.5 won't communicate with 10g
> > and vice versa.
> > Too many major releases in between.
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
> Hi ,
> Actually it's okay if it doesn't communicate . But can I have
> some serial connections i.e., connect to 10g , get the data , close the
> 10g connection , then connect to 8 and execute some stored procedures .
>
>
> In tha case , what should my Environment variables link $ORACLE_HOME
> and $LD_LIBRARY_PATH should be ?
>
> Thanks !

Easier would be two programs:
one compiled for 8i
one compiled for 10g

then pipline the data between them. (or shared memory, or text files, whatever)
Anyway, no need to keep opening/closing ORACLE connections and no funky build process.

   HTH,
   Ed Received on Tue Sep 05 2006 - 11:59:01 CDT