Heterogeneuos Services on Suse Linux 64 bits (From Interbase to Oracle 10g)
Hi all,
I need to migrate a database from Interbase 6 to Oracle 10gR2. So, I was using heterogeneous services ODBC. So that i am not getting any successfull.
All steps was configured correctly: Listener, tnsnames, odbc.ini, dblink on oracle and so on.
The test with isql tool of the unixODBC is running ok connecting to the interbase, so that inside sqlplus when a try to select using dblink show me the following error:
SQL> select count(*) from cliente@sb;
select count(*) from cliente@sb
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from SB
I had read Heterogeneous Connectivity Administrator's Guide and there is write that ODBC agents are supported on Linux (x86) 32-Bit platforms.
So, is there another way or another Oracle tool that I can use to take the rows from Interbase 6 to Oracle 10gr2 ?
Thanks.
Wander(Brazil)