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=0x5Please 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
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
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.