Which JDBC driver to use with MS Access?

[Former Member]

I have checked out <a href="http://http://developers.sun.com/product/jdbc/drivers">http://developers.sun.com/product/jdbc/drivers</a> and found more than 20 drivers supporting querying an MS Access DB.

Can anyone recommend any one in particular?

Henning

[Former Member · Accepted solution]

Hi Henning,

If you are not intending to use the JDBC-ODBC bridge connectivity provided by SUN (part of JDK - sun.jdbc.odbc Java package), and you need to focus on the commercial 'pure JDBC' drivers, then you might want to do your selection based on:

- The driver 'Type' and its compatibility with your server deployment platform

- The driver JDBC API release level

- The driver purchasing cost

Again, the Sun <a href="http://developers.sun.com/product/jdbc/drivers">tool</a>) you indicated will provide you with a initial vendor list you can drill down further.

Hope this helps.

Regards,

Joseph

[Former Member]

Hi Henning.

check this link

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/main

Regards,

P.Manivannan

[Former Member]

Is there an answer to my question there? I know about the WIKI and have found the link to Sun's driverpage there, but I haven't found more about connecting to MS Access in the WIKI. If there is, please guide me.

Henning