• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Accessing Remote Databases

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 192
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Use JDBC
Thank you
Garandi
 
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic