Hello all, I am trying to connect to a Remote DB2 dtaabase. I have the following information ServerName: INDIA IP Address:1.95.23.817 username:gpdb2user password:gpdb2user InstanceB2 Database:REG I am currently using the following fromat url= "jdbc b2:@1.95.23.817:INDIA:REG" I really doubt if this right, Can some one tell me if i am doing it right , if not the best way to call in this situations. Thanks in advance, I am in stake mate at this point, unless some one helps me i cant go further, So pls suggest me asap. Thank you Regards Vikram
Bruce Jin
Ranch Hand
Joined: Sep 20, 2001
Posts: 666
posted
0
I think you need to have a driver that supports remote database access. For example, IBM tollbox (http://www-1.ibm.com/servers/eserver/iseries/toolbox/ ) has a jdbc driver that allow people to connect to remote DB2. (this remote db2 maybe limited to AS400 db2).
BJ - SCJP and SCWCD
We love Java programming. It is contagious, very cool, and lot of fun. - Peter Coad, Java Design
The toolbox driver (for remote access as400 db2) is: com.ibm.as400.access.AS400JDBCDriver if you have an as400, the toolbox should be installed. its name is jt400.zip.
Monty Ireland
Ranch Hand
Joined: Oct 03, 2000
Posts: 161
posted
0
There may be another way to solve your problem. If you are using a UDB version of DB2. You can use Client Confifurations Assitant (cca) to help you. I can help ... if you are using a UDB version of DB2. I need to know few things first: 1. OS of client 2. OS of database server 3. version of java on client, web server, and/or database server 4. need to know how many machines. FYI, if you are using a UDB version of DB2. Connectivity should take about 15 minutes to setup and run from scratch !@# usiing CCA odbc and/or CLI 1st for about an hour will help you define IP address and/or db alias names [ December 27, 2002: Message edited by: Monty Ireland ]
0
B2
b2:@1.95.23.817:INDIA:REG"
