Re: Create database link for non-oracle database

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 22 Apr 1998 01:53:29 GMT
Message-ID: <t4c%.2$ih.264589@news.ipass.net>

Hi:

If I understood your question correctly, you will need Oracle Transparent Gateway for DB2/400. This allows you to create a dblink that connects to an AS/400. There is no way that I know of to have Oracle talk directly to an AS/400 using ODBC.

Good luck,
Dave

Ralf Mellis wrote in message <353d01e4.5087335_at_news.cityweb.de>...
>Hi,
>
>I'm trying to connect Oracle to an AS/400-System with ODBC.
>The direction AS/400 --> Oracle is no problem, but the other
>(Oracle --> AS/400) is.
>I have a valid ODBC-Connection to the AS/400-System.
>Is it possible to connect FROM Oracle to this ODBC-DSN?
>
>It may function with the statement CREATE DATABASE LINK,
>but I don't know how to define the parameters.
>
>The Oracle-documentation to this statement says: It is possible
>to connect to oracle AND non-oracle-databases. (But there is
>no example for a connection to a non-oracle-database).
>
>Hoping for answers
>
>Ralf Mellis
>ralfmellis_at_cww.de
>
>
Received on Tue Apr 21 1998 - 20:53:29 CDT