How to connect to remote Database Using IPAddress

[vikram nalagampalli]

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
Instance:DB2
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]

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).

[Bruce Jin]

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]

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 ]