Re: connecting to db2 database

glipuma_at_hotmail.com (gina) wrote in message news:<926fc4d4.0207031140.432b84e3_at_posting.google.com>...
> is there a way to connect from oracle to a db2 database, specifically
> a jdedwards db? have no clue even how to start this off. what will
> happen is i will pull data from a db2 table into an oracle table. any
> ideas how to make that connection? thanks..

You neglected to mention your Oracle version and OS.

If you are on Oracle version 8.1.x and above, *theoretically and not tested* you should be able to use Oracle's java cartridge and DB2 jdbc driver like COM.ibm.db2.jdbc.net.DB2Driver to make the connection...i.e. if DB2 jdbc driver is compatible with Sun's JDK 1.2.1 which ships with Oracle version 8.1.7. For more info on DB2 side...please post in DB2 newsgroup comp.databases.ibm-db2

HTH
//Rauf Sarwar Received on Thu Jul 04 2002 - 08:31:44 CEST