aspose file tools*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Production quality JDBC-ODBC driver?" Watch "Production quality JDBC-ODBC driver?" New topic
Author

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,
Craig
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

here is a list from sun:
http://industry.java.sun.com/products/jdbc/drivers/search-results/1,2722,,00.html
You will probably have to pay for them though.
Jamie
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,
Craig
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Production quality JDBC-ODBC driver?