vendredi 15 janvier 2016

Can't access encrypted sqlite database

I used Navicat Premium to create the database file and selected encrypted to put a password. Now when I try accessing the database in my vb.net program I get an error saying...

file is encrypted or is not a database

"Data Source=\\10.10.10.10\Folder\database.db;Password=pwd;Version=3;", True

The above is my connection string (please ignore the network path =) ). Anyway, I can get through opening the connection but when reading data I get the error. I tried creating another database that doesn't have a password and it worked fine. I even copy pasted the password I have in code to navicat to make sure i typed it correctly.

Aucun commentaire:

Enregistrer un commentaire