jdbc odbc bridge

[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.

[John Carnell]

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]

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?