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??
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.
When i want to selecht drivers, i have no option for the sun.jdbc driver, while my friend with windows does have the option.
When i try to open your link i get a white page.....
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.