Hi, as far as I understand the db(duplicati-server.sqlite) is RC4 encrypted.
I have build a duplicati-server.sqlite using the DUPLICATI_DB_KEY environment variable
to have a sqlite with a known key.
Would like to access it from MSAccess - so I installed Devarts ODBCDriver for SQlite.
During creation of then ODBC data connection I entered the ‘own’ DB password and selected RC4
encryption - but it constantly refused to connect the sqlite file by refusing the password
but I can open the encrypted DB (with own pw) in other sqlite applications (sqlite2009 Pro enterprise mgr).
Would at least like to build some simple reporting or even more … :-).
Any ideas on this or can you recommend me an ODBC driver for sqlite supporting this?