aspose file tools*
The moose likes JDBC and the fly likes How to connect to remote Database Using IPAddress Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to connect to remote Database Using IPAddress" Watch "How to connect to remote Database Using IPAddress" New topic
Author

How to connect to remote Database Using IPAddress

vikram nalagampalli
Ranch Hand

Joined: Oct 08, 2001
Posts: 91
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: 671
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

Crazy Bikes created by m-Power
Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 671
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
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 ]

Multi Platform Database Developer & DBA on E.S.T.
 
wood burning stoves
 
subject: How to connect to remote Database Using IPAddress