Re: PRO C for two database

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 5 Sep 2006 18:11:58 GMT
Message-ID: <J54t81.B7p@igsrsparc2.er.usgs.gov>

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 !
>

The problem comes in when trying to compile your Pro*C app. You can compile it with Oracle 8 libraries or with Oracle 10g libraries, but not both. And it is the libraries that give you the network connectivity to the database. You can test it out compiling the app under one version or the other, but I would suspect that you will see errors when connecting to the *other* database version.

Any reason why you cannot upgrade the Oracle 8 db to at least 9i?

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Tue Sep 05 2006 - 13:11:58 CDT