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