How to connect to ExampleData data Sources?

Questions
, ,
1

Hello, I am trying to connect to a Microsoft Access database (.accdb) file that a colleague shared with me,using DatabaseLink, and I cannot seem to get this to work. To rule-out a problem with my .accdb file, I also tried to connect to a file provided with the Example Data package, “publishers.ccdb.”

Needs["DatabaseLink`"]
conn = OpenSQLConnection[
   JDBC["Microsoft Access(ODBC)", 
    "/Users/c-space/Library/Mathematica/DatabaseResources/Examples/
     publishers.accdb"]];

When I follow the guidelines on the reference page (Database Connections—Wolfram Documentation) for ODBC Connections, I get the following error:

JDBC::classnotfound: sun.jdbc.odbc.JdbcOdbcDriver >>

Note, the connection method I am using is access-specific ODBC driver and a path to the Access file. (This method does not require a configured ODBC source.)

What I’ve tried so far:
Clean restart of mathematica. (Wolfram Support Quick Answers: How do I fix common problems by resetting Mathematica 14.0 to its default configuration?)
Install and Restore the database examples to their original state as described in “Using the example Databases.”

Is there anybody else out there who has run into this issue before?

2

You’re probably using Java 8, which doesn’t have the JDBC-ODBC bridge. If connecting to Access (rather than exporting the database) is a necessity, you could downgrade to JDK 7.