Re: oracle ingres gateway

Michael Leo wrote in message <4.1.19990916081559.01b944f0_at_mail.visi.com>...
>At 01:10 AM 9/16/99 +0000, morella3253_at_my-deja.com wrote:
>>Hi,
>>
>>I have a seen a program recently which allows the program
>>to connect to an ingres database and an oracle database.
>>This is done without a gateway by linking a .sc program with
>>the oracle equivalent program which is a .pc
>>(using the proc utility).
>>
>>I do not know how to link the two programs. Please help.
>>
>>Morella.
>
>This is extremely tricky. Depends on the platform,
>and it requires proper separation of the compilation
>modules.
>
>There are people who say it cannot be done, but I
>have done it, and it CAN be done. It isn't easy
>because both mess around with signals.
>
>I would suggest and easier alternative:
>
> Use either the OpenIngres OpenAPI and OCI, or both.
>
Or use perl with DBI, DBD::Ingres and DBD::Oracle. It is possible to connect to many databases simultaneously. The bases can be of the same or different makes.
Several sites have used this to migrate their data from Ingres to Oracle.

---
Henrik Tougaard,
WM-Data Datani, Software Consultants, Copenhagen Denmark