No connection to MS Access Database

Hi,

I have a problem to connect KNIME with my MS Access Database.

I get the following error message:

ERROR Database Connector   0:1        Execute failed: Could not create connection to database: Driver "org.sqlite.JDBC" does not accept URL: jdbc:odbc:DRIVER={Microsoft Access Driver (.mdb, .accdb)};DBQ=C:\Workspace\Datenbanken\SurgicalManager.mdb

My configuration is:

  • Windows 7 (64-bit)

  • KNIME (v3.1.1.v201512111505)

  • Microsoft Access Database Engine 2010 Redistributable

  • I installed my MS Access Driver (32-bit) at: C:\Windows\SysWOW64\odbcad32.exe

  • installed the Microsoft Access Driver (.mdb, .accdb)

Any ideas what is going wrong?

Kind regards,

Sevenhills