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 />email@example.com<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>
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?