views:

50

answers:

2

I do data conversions, and I am constantly connecting to a variety of different DBMS'. Certain DBMS' do not have JDBC drivers (MsAccess for example). Sun's JDBC-ODBC bridge driver was meant as a short term solution when JDBC drivers weren't widely available, and because of that, it is lacking functionality and is pretty buggy. I am told that there are good commercial solutions available, I have yet to find any, however. Does anyone know of any good bridge drivers?

+2  A: 

use this form, and select ODBC from the 'supported dbms'. that way you should be able to find one that also meets your other needs.

pstanton
A: 

Simba has an ODBC and JDBC SDK that contains a JDBC/ODBC bridge. Basically, the SimbaEngine SDK is a toolkit that allows you to quickly build an ODBC driver. Many of our customers also want a JDBC driver. So, we developed a JDBC/ODBC bridge as part of the SDK to fill this need. The way the driver is put together, allows you to take the JDBC/ODBC bridge and use it to connect to any ODBC data source. If you want, we have a free evaluation download. Go to http://www.simba.com/evaluate-odbc-sdk.htm. In the project overview, explain that you want a JDBC/ODBC bridge and you are looking to use the Simba Client/Server component.

Amyn Rajan
Thanks, I will check it out.
Eric Milas