Can I use the JDBC to ODBC bridge to connect to a Sybase database? If so are there any drawbacks to doing so? Thanks, Frank
posted 16 years ago
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.
SOURCE CODE should be SURROUNDED by "code" tags.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads