jdbc to odbc

Hi,

You can use the JDBC/ODBC bridge to connect to any ODBC compliant database. This includes Sybase, Ms-Sql, Oracle, Informix, Access, Foxpro, MySql, msSql etc etc.

As for the drawbacks when using JDBC:ODBC, there are many. It's slow, it's sluggish and it does not offer the full JDBC2 package. Alot of methods are just plain inaccessible with this driver.

Mostly ODBC bridge driver should only be used for testing and developement.

Please go through the following URL's:

http://java.sun.com/products/jdbc/index.html

Vendors of Drivers: http://industry.java.sun.com/products/jdbc/drivers

Hope this will help you.

Anil.

Developer Techncial Support

Sun Microsystems Inc, India.

http://www.sun.com/developers/support

ramanil_indts at 2007-6-29 12:44:23 >