Message Boards Message Boards

How to connect to ExampleData data Sources?

Posted 9 years ago

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 (http://reference.wolfram.com/language/DatabaseLink/tutorial/DatabaseConnections.html) 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. (http://support.wolfram.com/kb/12464) 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?

POSTED BY: Caitlin Ramsey

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.

POSTED BY: Jesse Friedman
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract