Re: Database Link to DB2

If you are looking at purchasing software you should consider DataMirror's Transformation Server. Transformation Server offers high performance peer-to-peer real-time data integration between heterogeneous databases (Oracle, DB2 UDB, Sybase, PointBase, MS SQL Server ...) with support for on-the-fly transforms. More information is available by visiting www.datamirror.com.

Thanks
Amy

"massimo camporesi" <massimo.camporesi_at_gruppopro.it> wrote in message news:<9kublf$1f0$1_at_pinco.nettuno.it>...
> I give you some more details.
> The database link comunicates with the AS/400 but when issuing a command on
> SQLPlus I get:
> ORA-02085 database link is connected to HO.WORLD
>
> Do someone know what is 'HO.WORLD' ? It is not one of my objects .
>
> Thanks
>
> "massimo camporesi" <massimo.camporesi_at_gruppopro.it> ha scritto nel
> messaggio news:9kqtp4$238$1_at_pinco.nettuno.it...
> > I'm trying to configure a database link from an Oracle 8.1.7 on Win2K to
> a
> > DB2 7.1 on Win NT.
> >
> > What I have configured:
> >
> > - ODBC driver for DB2 named PROGET
> > - in listener.ora :
> > (SID_DESC =
> > (PROGRAM = hsodbc)
> > (SID_NAME = PROGET)
> > (ORACLE_HOME = D:\ORACLE\ORA81)
> >
> > - in tsnames.ora:
> > PROGET.GRUPPOPRO.IT =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = bownt00s376)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = PROGET)
> > )
> > (HS = OK)
> > )
> >
> >
> > Then I created a database link with the command:
> > CREATE PUBLIC DATABASE LINK 'PROGET.GRUPPOPRO.IT' CONNECT TO 'DB2ADMIN'
> > IDENTIFIED BY 'DB2ADMIN' USING 'PROGET'
> >
> > When testing the link I get the message : 'The Database Link is not
> active'
> >
> > Network configurations semms to be correct because, while testing, I
> > register network activity on DB2 and ODBC trace registers no errors.
> >
> >
> > Can someone help me ?
> >
> > Thanks
> >
> >
> >
> >
Received on Thu Aug 16 2001 - 13:04:45 CDT