Hi there,
I am new to Knime, and am having problem connecting a SQLite base.
I use Knime 2.7.4, whose folder is located in my Home folder (Linux Ubuntu), I installed the SQLite driver sqlite-jdbc-3.7.2, and my database file is on my Desktop: 20130411ThymNoco.db
I enter my base URL in the Database Reader Dialog: jdbc:sqlite:/20130411ThymNoco.db click apply, and get the following message: WARN Database Reader java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: opening db: '/20130411ThymNoco.db': permission denied
Please note that this database can be opened and queried with Sqlitemanager.
If i modify the URL to: /Desktop/20130411ThymNoco.db, I get the message: WARN Database Reader java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: path to: '/Desktop/20130411ThymNoco.db': '/Desktop' does not exist
What am I doing wrong?
Thanx in advance for your help!
I attache a screen shot of the error message with different assays