Forums Register Login

JDBC-ODBC bridge

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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.
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
https://gardener-gift.com


reply
reply
This thread has been viewed 922 times.
Similar Threads
regarding JDBC-ODBC Bridge Driver
regarding JDBC ODBC bridge(native client code)
Sun jdbc odbc bridge error
Basic Doubt!!
Server stops automatically with EXCEPTION_ACCESS_VIOLATION
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 03:35:40.