This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Production quality JDBC-ODBC driver? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Production quality JDBC-ODBC driver?" Watch "Production quality JDBC-ODBC driver?" New topic

Production quality JDBC-ODBC driver?

Craig Demyanovich
Ranch Hand

Joined: Sep 25, 2000
Posts: 173
I need to connect to a data source that can only be accessed via ODBC: it's so proprietary that no driver exists for it or its underlying file structure. In addition, the data source is designed such that, to use ODBC, a program must go through a 'client' that forwards the calls to the 'ODBC server.' This client runs only on Windows. I CANNOT rely on the quality of Sun's JDBC-ODBC bridge for this project. Is there a production-quality JDBC-ODBC bridge?
Thanks for your time,
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

here is a list from sun:,2722,,00.html
You will probably have to pay for them though.
Craig Demyanovich
Ranch Hand

Joined: Sep 25, 2000
Posts: 173
I tried such a search earlier, limiting the results to the JDBC 2.x API. The results were few, but the one thing they had in common was that they each involved a client and a server. The client was really a .jar for the CLASSPATH, like any other JDBC driver. Calls to it would be forwarded to its server, which would translate the calls to ODBC calls, which would then be forwarded on to the data source. We could put the client and the server on the same machine, the server could forward calls to this proprietary driver I mentioned in my last post, and then that driver could forward the calls to the server. I was, however, hoping not to take this "scenic" route; I would rather use a production quality JDBC-ODBC bridge.
Thanks for the response,
I agree. Here's the link:
subject: Production quality JDBC-ODBC driver?
Similar Threads
ODBC and Microsoft access
Jdbc Odbc Bridge Driver
JDBC + MS Access without ODBC data source
Excel Data Population using Java
JSP - Unsupported Operation Exception