Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problem getting tables from DB2 to 8i through ODBC

I have a problem while getting the tables from DB2 to Oracle8i through ODBC (Client Access ODBC Drivers(32-bits)). First I created a dsn as400_conn through ODBC, then I tried from SQL the following:

 SQL> copy from dummy/dummy@odbc:as400_conn - 
 to dummy/dummy@as400 replace ttt using - 
 select * from leath 
 
 Array fetch/bind size is 15. (arraysize is 15) 
 Will commit when done. (copycommit is 0) 
 Maximum long size is 80. (long is 80) 
 
 ERROR: 
 OCA-30017: error logging on to non-Oracle database 
 [IBM][Client Access ODBC Driver 
 (32-bit)][DB2/400 
 SQL]Communication link failure. COMM RC=0x5 
Please help me get the table into Oracle.

If I try the same technique through VB or ACCESS, it works fine. Also I need to automate this to run every midnight.

In Oracle, if you want to connect to a non-Oracle database, then you need to use a product called Transparent Gateways (formerly called Heterogenous Services). With this product installed, all you need is an ODBC connection to the non-Oracle database. Then, you create a database link in Oracle that uses this ODBC connection. Without Transparent Gateways, this database link cannot be created. After that, you query the non-Oracle database just as if it were another Oracle database across the link. The Oracle docs has tons of information on how to set this up.

For More Information

This was last published in December 2002

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close