aspose file tools*
The moose likes JDBC and the fly likes jdbc odbc bridge Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc odbc bridge" Watch "jdbc odbc bridge" New topic
Author

jdbc odbc bridge

vamsi bezawada
Greenhorn

Joined: Dec 28, 2000
Posts: 16
Hi everybody,
Samll doubt. Is it possible to connect to remote server with out having client installed on local machine using jdbc dbc bridge ?
Thank you,
bye,
vamsi.
John Carnell
Author
Ranch Hand

Joined: Sep 27, 2002
Posts: 71
Originally posted by vamsi bezawada:
Hi everybody,
Samll doubt. Is it possible to connect to remote server with out having client installed on local machine using jdbc dbc bridge ?
Thank you,
bye,
vamsi.


Hi Vamsi,
No. If you are going to use the JDBC-ODBC bridge you need to have the database middleware and ODBC driver installed on the client. For instance, if I am using Oracle, the Oracle JDBC driver and the JDBC-ODBC driver, I would need to have the following software installed and configured:
1. Oracle ODBC Driver installed and configured
2. SQL*NET with a valid tns-names.ora file
3. The jdbc-odbc drivers installed.
Hope that helps.
Thanks,
John Carnell


John Carnell<br />Principal Architect<br /> <br />Netchange, LLC<br />1161 HillCrest Heights<br />Green Bay, WI 54313<br /> <br />john.carnell@netchange.us<br /> <br /> <br />Author of <a href="http://www.amazon.com/exec/obidos/ASIN/159059228X/ref=jranch-20" target="_blank" rel="nofollow">Pro Jakarta Struts, Second Edition</a>
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Sun says this It doesn't matter if you do or don't have the driver locally because the odbc bridge doesn't ensure remote access to databases. Most databases have a free driver available that supports remote access to the specific database( other than ODBC). Which database are you using?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: jdbc odbc bridge