• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

How to connect to remote Database Using IPAddress

 
Ranch Hand
Posts: 91
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 672
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 672
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Your mind is under my control .... your will is now mine .... read this tiny ad
create, convert, edit or print DOC and DOCX in Java
https://products.aspose.com/words/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!