At 05/13/2002 11:41 AM (Monday), valenciandawn wrote:

>1 - Normal SQL queries that request data from Oracle and store it in
>local Fierbird tables.

I don't know how you would do this so I think it is not a real alternative.

>2 - An application in Delphi Object Pascal (or another lenguaje that
>can access both Oracle and Firebird) that conects to Oracle and
>Firebird and transfer the data.

This is your only real alternative. Choice 3 (below) is just a variation on
this. I would use Delphi together with IBObjects components for Firebird
access and Direct Oracle Access (DOA) components for Oracle access. Both of
these are native libraries.

>3 - ODBC links (is it a madness? ;))

This would not be your optimal solution since neither Oracle or Firebird
are native ODBC speakers.