2

In version V 1.0.113.1 of package system.data.sqlite the function ChangePassword is no longer supported.

Users must have the possibility to change the password of an SQLite database. I know this function of SQLite for many years.

In the forum SQLite you can find the poor statement that the function is "not supported" and therefore dropped. If this remains so, you will be forced to change to another database system in the future, or is there another possibility to change the password of a database?

GerdV
  • 21
  • 1
  • I would suspect that the package developers have reasoned that changing the password is an administrative task and doesn't really belong in this package - I would look to see if there's another package covering admin interactions – Stewart Ritchie Jun 19 '20 at 10:07
  • The function has been in existence for about 15 years. It is not possible to understand why it has been dropped. I will rollback to version 1.0.112 and use a different database system in the future, because SQLite is not backward compatible. A disaster for existing applications. – GerdV Jun 20 '20 at 13:14
  • Maybe this link is a solution: https://stackoverflow.com/questions/62294577/where-is-setpassword-or-changepassword-in-sqliteconnection-class?answertab=active#tab-top – GerdV Jun 20 '20 at 13:24
  • see other options here - https://stackoverflow.com/a/66005918/426315 – itsho Apr 07 '21 at 09:43

0 Answers0