MS ACESS MEETS H2

KNIME Analytics Platform
1

When I try running the MS Access connection under the 02_Database option07_MSAcess, I get an error message and I am unable to proceed beyond the Table Row to variable.  At the databaase connector, I get an error. "Could not create connection to database........"

Would somebody in the forum guide me as to how to resolve it.

 

Thanks

2

Hi PKRISH,

Have you added a JDBC driver to connect to your MS Access database? You need to do this first in order to establish a connection. Please have a look at this blog post to learn how to do this: https://www.knime.com/blog/will-they-blend-experiments-in-data-tool-blending-today-ms-access-meets-h2-test-your-baseball

Cheers,

Roland