ODBC driver

KNIME Analytics Platform
1

'Hi

I'm trying to make a connection to an acces database (.accdb), but I don't see an ODBC driver when I try to configure a Database Reader or a Database Connector node. I only have JDBC drivers in the Databse Driver dropdown list.

Please help me get the ODBC driver in my Knime.

Thank you in advance

Ps. I have configured my database in the "ODBC data source administator" in Windows

2

There is no free ODBC driver for Java (any more). Any decent database has a native JDBC driver for Java, even MS Access. There are already a couple of post in this forum about connecting to Access.

3

Hi,

please have a look at this thread for more details about why we no longer support JDBC/ODBC and how to connect to Access.
Bye

Tobias

4

Thans for the reply, it works now :)