Forum Stats

  • 3,768,991 Users
  • 2,252,892 Discussions
  • 7,874,830 Comments

Discussions

No suitable driver found for Microsoft Access Driver

93a8db5e-c0f1-48bc-a914-a7ea775d8871
edited Mar 4, 2015 8:43PM in Java 8 Questions

Hello,

I have this xml parser that writes to a microsoft access .MDB file. We've been using it for many years, the last time I had successfully used the app was around January. But when I tried the other day I got this message:

No suitable driver found for jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Users\Robbie\

Desktop\products.mdb

I was using some 7.x revision and so I attempted to uninstall that and install the latest 8.x with no difference.

I tried uninstalling and reverting to a 6.0 release and got this instead

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I've tried on another pc as well with the same issues. All of my pc's have Office 365 installed

Answers

  • Unknown
    edited Mar 4, 2015 8:43PM
    I have this xml parser that writes to a microsoft access .MDB file. We've been using it for many years, the last time I had successfully used the app was around January. But when I tried the other day I got this message:
    No suitable driver found for jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Users\Robbie\
    Desktop\products.mdb
    
    I was using some 7.x revision and so I attempted to uninstall that and install the latest 8.x with no difference.
    
    I tried uninstalling and reverting to a 6.0 release and got this instead
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    
    I've tried on another pc as well with the same issues. All of my pc's have Office 365 installed
    

    The JDBC-ODBC bridge has been removed from Java version 8:

    JDBC-ODBC Bridge

    Status of the JDBC-ODBC Bridge

    The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8. In addition, Oracle does not support the JDBC-ODBC Bridge. Oracle recommends that you use JDBC drivers provided by the vendor of your database instead of the JDBC-ODBC Bridge.
    

    You will need to find a JDBC driver from Microsoft or another vendor.