Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
No suitable driver found for Microsoft Access Driver

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
-
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:
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.