New data source, secure with password error

Hi,
It seems that you have created an empty database. Is it a SQL Server database? You need to initialize it first.

It's a SQLite. I did Data sources, Add a new data source, chose SQLite, OK, gave it a name and checked Secure with password and gave a password.
So next test I did the same, but did not check secure with password or give it a password, it created it ok, and I was able to add entries, but if I went back into data sources and then tried to check secure with password and add a password. then choose that data source to open I get the file is encrypted or is not a database error.

Ok,
Remove the check and use the File->Change masterkey to assign the password.

David, the master key only locks the editing or the datasource attributes. I would assume that the secure with password option would prompt each time someone wanted to view that datasource. I am getting the same results as Bills, how can we get "secure with password" to work?

Ross

Hi Ross,
Have you checked the Always Ask for password for the data source? What data source type do you use?

I am using sqlite and yes I checked "always ask". No matter what I do, I get "this password is invalid or a password is not required"

Hello Ross,

Firstly, you need to define a password in File -> Manage Password.

Secondly, you click on File -> Data Source, edit your SQLite data source and check Always ask password.

Now, if you close and restart RDM, you should see a prompt to enter a password to login on the SQLite data source.

Best regards,