Hi Thomas,
I am using a Win7 (64-bit) OS and am trying to connect to a MS Access 2007 database.
I tried both the methods to connect to a access 2007 database. If I am using 32-bit KNIME, then both the methods successfully connects to access databases.
But when using 64-bit KNIME, the same model that worked under 32-bit KNIME, fails to connect to .accdb. The error messages slightly differ depending on the method used:
1) method1 connecting via ODBC DSN produces this error- "ERROR Database Reader Execute failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
2) method2 connecting directly produces this error: "ERROR Database Reader Execute failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"
Is it possible to connect to .accdb from 64-bit KNIME?
Thank you,
kannan