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 ODBC  & JDBC Connection 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 "ODBC  & JDBC Connection" Watch "ODBC  & JDBC Connection" New topic

ODBC & JDBC Connection


Joined: Jun 05, 2001
Posts: 1
I am using JDBC to connect to ODBC, something like
String url = "jdbc dbc:login";
Connection dbconn = DriverManager.getConnection(url,"wolf","");
But it has some restriction, both JDBC and ODBC should be in the
same local machine, right? So if the ODBC is installed in another machine, then anyone knows what is the format of the "url".
thanks a lot
kichu kichu
Ranch Hand

Joined: May 10, 2001
Posts: 59
As far as i know ,the code given below is the standard way a database connection can be obtained.
Try installing the odbc driver and jdbc driver onto the same machine.
String url="jdbc dbc:"+dsn;
Connection con=DriverManager.getConnection(url,username,password);
return con;

[This message has been edited by kichu kichu (edited June 06, 2001).]
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
The type 1 driver, JDBC-ODBC Bridge, translates all JDBC calls into ODBC (Open DataBase Connectivity) calls and sends them to the ODBC driver. As such, the ODBC driver, as well as, in many cases, the client database code, must be present on the client machine.

Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
I agree. Here's the link:
subject: ODBC & JDBC Connection
It's not a secret anymore!