Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc odbc bridge

 
vamsi bezawada
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic