• Post Reply Bookmark Topic Watch Topic
  • New Topic

Accessing Remote Databases  RSS feed

 
zeeshan ansari
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have situation where a database is in a city which gets constatntly updated and i want the program that is running on a machine on different city to query and use that data base.... please suggest a proper technology and resources through which i can become able to make such system
 
Garandi Garandi
Ranch Hand
Posts: 192
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use JDBC
Thank you
Garandi
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You configure database drivers for different databases in different ways, but at some point you have to specify things like the database server machine name and port. The machine name can be somewhere on a corporate network or the Internet. For example, here's how I connect to SQL Server 2000:

mConnection = DriverManager.getConnection("jdbc:microsoft:sqlserver:" + name, userid, password);

The "name" parameter is something like "//bigserver:1234". If you can ping the server you oughtta be able to connect. My DB2 driver requires me to go through a DB2 client configuration tool and set up an alias for the machine & port information.

What database & driver are you using? Does this help?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!