Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I connect to a DB2 database from Oracle 10G on linux?

434755Dec 15 2004 — edited Jul 28 2011
Hi

I have tryed to connect to a DB2 database from oracle 10 G on linux.

I have installed unixODBC and a db2 odbc driver. I can connect to the db2 using isql, but oracle comes with this error:

-----------------------------------
select * from testtable@acc_spc_gr2
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: DB_ODBC_INTERFACE (718): ; [C077]
Could not find symbol 'SQLAllocConnect' in dynamic library
DB_ODBC_INTERFACE (722): ; [C079] Failed to load dynamic library
'/opt/ibm/iSeriesAccess/lib/libcwbodbc.so'
ORA-02063: preceding 3 lines from ACC_SPC_GR2
--------------------------------------------

What am I doing wrong? Any one have a guide to do this?

- Jesper
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2010
Added on Dec 15 2004
8 comments
6,039 views