Hi fellow Knimers,
I am fairly new to knime and finding out how useful a tool it is.
Currently, I have spent a fair bit of time googling and reading the forums about connecting access with knime.
I can read and write to my access databases, however, it displays behaviour I am struggling to troubleshoot.
Everytime I open the workspace the “Database Table Connector” will output the following error:
Database Table Connector 2:4 Execute failed: java.io.IOException: Connection to database 'jdbc:ucanaccess://H:/METERING/Meter_Provider/EMA Reporting/EMA Reporting.accdb;memory=false;showsschema=true' timed out
But when I run the node again or open the node and click ‘Fetch Metadata’ it will then work there after.
This is a problem because I would like to batch script the workspace to run automatically and I need it to be reliable.
Thank you in advance for any guidance and thoughts on the topic.