Re: Conversion of Ingres 4GL to 'C' .exe and accessing any oracle & Ingres

Home -> Community -> Usenet -> c.d.o.misc -> Re: Conversion of Ingres 4GL to 'C' .exe and accessing any oracle & Ingres

From: Michael Krolewski <mkrolews_at_upw.com>
Date: 1997/07/17
Message-ID: <33CF02D1.2260@upw.com>#1/1

> > we want to access Oracle database from ABF/vision(Ingres 4GL). We
> >have one option of doing this.
> > Converting the Ingres 4GL to 'C' and embedded SQL and then to 'C'
> >executable and then accessing the Oracle database as well as Ingres
> >database.If anybody had done this please respond with the following
> >information.
>

I am not absolutely sure, but Oracle does have the Transparent Gateway products.
They are pricy -- Oracle to Sybase gateway was $12,000. It gives you a simple mechanism , you write everything in Oracle to the tables in the foriegn database.

The major advantage is that the Transparent Gateway is almost as fast as naive code.

Another choice would be to use ODBC (if accessing the database from a PC). It can
be slow and clumsy, but it gets the job done.

Mike Krolewski. Received on Thu Jul 17 1997 - 00:00:00 CDT