SQLite Password protection DB

KNIME Analytics Platform
1

Hello,

I have a database file (test.db) that I would like to read into KNIME.
The DB is protected with a password.
I can access it via SQLiteStudio with the database type: System.Data.SQLite.
How can I establish the connection in Knime?
If i try to use the SQLite Connector i get an error like this:
java.sql.SQLException: Cannot get schemas from database. Reason: [SQLITE_NOTADB] File opened that is not a database file (file is not a database)

Thanks.

2

Hello @TimKu ,
Could you please share the screenshot of the configuration window of the SQLite Connector node so that we can have a look?

Thanks,
Sanket

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.