Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC-ODBC bridge

 
Frank Hale
Ranch Hand
Posts: 230
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
John Bateman
Ranch Hand
Posts: 320
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 Reply
  • Bookmark Topic Watch Topic
  • New Topic