How to connect to sqlite database with password
you can provide password via connection string;
from ConnectionStrings.com
Data Source=filename;Version=3;Password=myPassword;
Also, have a look at his link
hope it helps
This is the connection string with password
Data Source=filename;Version=3;Password=myPassword;
As you stated that you use navicat to set the sqlite encryption. Encryption means that you've encrypted the database it's different from setting a password to a database..
in setting a password to a database try this code..
//create file
SQLite.SQLiteConnection.CreateFile("c:\\mydatabase file.db3")
Dim cn As New SQLite.SQLiteConnection
//set password
cn.ChangePassword("paxword")
//remove password
cn.ChangePassword("")
Remove the encryption first ..