File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC:ODBC bridge for remote access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC:ODBC bridge for remote access" Watch "JDBC:ODBC bridge for remote access" New topic

JDBC:ODBC bridge for remote access

Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336

I want to know if the JDBC DBC bridge can be used to access a Database on a remote machine. If it can be done, what do I specify in the URL for the DriverManager.getConection() method.

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
Yes, that works. In the URL you just provide the name of the ODBC data source. That name is set up on your machine in the ODBC control panel; simply point it to a remote data source This works on Windows only, but since Access is Windows-only as well, that may not be a big deal. There's an FAQ here.
Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336
I found out a solution to the problem. My MS Access DB is going to be on a Shared drive on my network. So in order to access the DB remotely using the JDBC: ODBC bridge, I need to pass this URL into the getConnection() method :
con = DriverManager.getConnection("jdbc dbc river={MicroSoft Access Driver (*.mdb)};DBQ=C:/data/Access/test1.mdb","dba","sql");

The other way to work around with the problem is to use the RmiJdbc bridge(Type 3 driver) or use the Jackcess Library which is more powerful and portable. But as I am building a small application where the DB server may not be moved, I would be using the JDBC: ODBC bridge itself.
I agree. Here's the link:
subject: JDBC:ODBC bridge for remote access
It's not a secret anymore!