Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ODBC & JDBC Connection

 
nuswolf
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai,
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.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc dbc:"+dsn;
Connection con=DriverManager.getConnection(url,username,password);
return con;

regards,
kichu
[This message has been edited by kichu kichu (edited June 06, 2001).]
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"nuswolf",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . 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.
Thanks.
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic