Microsoft access database driver mac

KNIME Analytics Platform
1

Hello,

For school we are using knime, and now we need to open a microsoft access database, but i can't seem to setup a legit connection. I am using a mac with OSX Yosemite (10.10).

I think it is because im missing the " sun.jdbc.odbc.JdbcOdbcDriver ".

Any help on this subject??

 

2

Hi,

the JdbcOdbcDriver is shipped with the KNIME installation so you are not missing this driver. However I do not have any experiences with ODBC connections on a Mac but you might want to have a look at the ODBC Administrator Tool for Mac to setup the ODBC connection.

Bye,

Tobias

3

Tobias,

When i want to selecht drivers, i have no option for the sun.jdbc driver, while my friend with windows does have the option.

4

Tobias,

When i try to open your link i get a white page.....

5

Hi,

my mistake. The Mac JDK does not contain the JdbcOdbc driver. Have you tryed using another JDBC driver to access the db such as decribed in this Stackoverflow post ? I guess it is simpler to use the UCanAccess JDBC driver to access the db directly instead of setting up the ODBC connection. On information about how to install a JDBC driver in KNIME have a look at the Database Documentation.

Bye,

Tobias