Accessing other databases

[mike777]

Hello all.
We have an Oracle database and an Interbase database.
On my local machine I can select data from either one using ODBC drivers.
I'm thinking there must be a way to access the Interbase database from the Oracle. Is there?
Could you possibly give me an example of how to do a simple SELECT to the Interbase from the Oracle?
Many thanks!!
-Mike Kemp

 

[jocave]

There are a couple of options. First, you can install Oracle Heterogenous Services/ Oracle Transparent Gateway. This allows Oracle to create a database link to non-Oracle databases which you can query just like any other database link. Second, if Interbase provides a type 4 (thin) JDBC driver, you can load that driver into the Oracle JVM and connect to Interbase via JDBC in a Java Stored Procedure.

Justin