Re: Retarget an Oracle OCI App to Rdb

In article <CMu93F.FvK_at_teleride.on.ca>, louk_at_teleride.on.ca (Lou Kates) writes:
> We have a large VAX/VMS application written in DEC's C that uses Oracle
> via the Oracle C Interface (OCI). Is there any middleware product available
> that would allow this program to work against a DEC Rdb database?
>
Having written Product->DB drivers for a number of databases, including RDB and OCI (see a public domain demo I released, anonymous ftp to ftp.std.com, in pub/gjc/siod-3.0-shar, it shows a similar driver structure between Oracle and RDB), I would say it would be extremely difficult and of low pay-off for a product to provide compatibility with all of the OCI "features" but certainly possible to hit the most likely features in a fairly good emulation on top of RDB SQL services. But that would imply an expensive middleware product that has consulting built-in to the purchase price.

In terms of minimizing pain it might be a good idea to hire a consultant experienced in multiple database call interfaces to help you do the port.

For one thing, you really *do* want to restructure your "db-driver-level" a bit so as to be able to hook into things like the Open DataBase Connectivity (X/OPEN style standards) in the future.

-gjc Received on Mon Mar 21 1994 - 10:00:27 CET