Home » Developer & Programmer » Forms » connecting to db2 udb from oracle d2k
connecting to db2 udb from oracle d2k [message #78329] Thu, 14 February 2002 00:26 Go to next message
Milind
Messages: 8
Registered: February 2002
Junior Member
Is it possible to connect to a db2 udb database from within oracle developer?.If so, can someone please guide me through the required steps?.

regards
Re: connecting to db2 udb from oracle d2k [message #78331 is a reply to message #78329] Thu, 14 February 2002 02:13 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Using normal ODBC connectivity, it is possible to connect to non-Oracle databases and work with them.
Re: connecting to db2 udb from oracle d2k [message #80042 is a reply to message #78329] Tue, 06 August 2002 06:31 Go to previous messageGo to next message
Praveen.K.C.
Messages: 1
Registered: August 2002
Junior Member
yes it is possible.
I have tested it with DB2 UDB 7.2 and Forms 6i Rel 2.You need to have Open Client Adapter installed.While connecting you have to say ODBC:XXX in the connection box.
Where XXX is the ODBC database name.
For OCA to work properly you need apply the latest ServicePack.
You could even call the back-end stored procs from Forms.
Re: connecting to db2 udb from oracle d2k [message #80993 is a reply to message #78329] Sun, 22 December 2002 23:39 Go to previous message
Srikrishnan GR
Messages: 1
Registered: December 2002
Junior Member
hi praveen

I am Srikrishnan, i read to ur message reg the abve can u please help me to connect D2k to DB2.

I had already done the following steps.

1. DB2 is installed

2. IBM Driver Connected with Data Base Name

3. In D2k Trying to connect with user id/passward@ODBC:ODBC name.

4. Error Message TNS Failure. Can u please verify the above and tell me the steps.

Can u please guide me what is OCA how to connect with?

please send me mail to krish_winner@hotmail.com or krish_36_2000@yahoo.com


Thanks and waiting for ur reply.


Regards

Srikrishnan GR
Previous Topic: how to code the update button in a form
Next Topic: Install Forms 6i and Database 9i In a PC
Goto Forum:
  


Current Time: Fri Apr 26 07:28:48 CDT 2024