You can use the JDBC/ODBC bridge to connect to ANY ODBC compliant database. This I beleive includes Sybase, Ms-Sql, Oracle, Poet, 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. Most documentation I have found claim (in my opinion, wisely) that the JDBC:ODBC bridge driver should ONLY be used for testing and developement. I actually take this one step further and ONLY use it for my prototypes. Look for a cheap/free Type 3 or Type 4 driver for your system. Info: http://java.sun.com/products/jdbc/index.html Vendors of Drivers: http://industry.java.sun.com/products/jdbc/drivers Hope this helps.
Post by:autobot
Any sufficiently advanced technology will be used as a cat toy. And this tiny ad contains a very small cat:
a bit of art, as a gift, the permaculture playing cards