Brian Peasland schreef:
> abhi147@gmail.com wrote:
>> Sybrand Bakker wrote:
>>> On 31 Aug 2006 22:23:06 -0700, abhi147@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
>
Would compiling against 9 be an option?
Should connect to 8, as well as 10

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...