raghuBavani

 Profile Answers by raghuBavani 

• Nov 20th, 2009

 

When ever, someone wants to access microsoft oriented databases such as MS Access, MS SQL server, you have to use the JDBC-ODBC bridge. In general, it is recommended not to use this type of bridge. Can anyone answer why it is not recommeded?

awasie

 Profile Answers by awasie 

• Nov 21st, 2009

 

We use JDBC-ODBC Bridge is when alternative of a pure-Java driver is not available. 

hsavinash2001

 Profile Answers by hsavinash2001 

• May 26th, 2010

 

It is not recommended to use because of the dependency on native language (This is implemented in C++)

vinaymudgil007

 Profile Answers by vinaymudgil007 

• Jun 7th, 2010

 

We use JDBC-ODBC bridge only when pure JDBC drivers are not available [say for connecting to a database] otherwise pure Java drivers are a good optoion.

The use of JDBC-ODBC drivers isn't recommended very much as ODBC would add an extra layer of interaction b/w the Java drivers and the actual database to be used i.e. ODBC layer would sit in between the database and Java drivers layer and extra calls to ODBC would be needed to connect to the desired database thereby slowing down the application performance and HENCE its not recommended.

Anything else, please let me know.

Thanks,
Vinay