I'm new to Knime and am having trouble opening a MS Access Database file of type "mdb". I'm using the Database Reader component. The Database driver is the default -- "sun.jdbc.odbc.JdbcOdbcDriver". I cannot seem to create a Database URL that works. I've tried the pathname to the target file. Also, I have tried things like jdbc:odbc:. I always get an error indicating that either the driver won't accept the url or a "datasource name too long" message.
Surely this is a simple thing to do -- I do it in java code all of the time:) Can anybody help me get on track?
This is a windows 7 machine.
Thanks in advance,