Access SQL Cipher 4 Encrypted database for Automation

SQLCipher Issues
1

Team,
Untill last month we were using SQLite database and recently to encrypt the database developer have changed it to SQL Cipher 4.

This was my code to access the SQLite databse

Sub TestSQL_Studio

 Set objConn = CreateObject("ADODB.Connection")
 Set objRecordset = CreateObject("ADODB.Recordset")
 
 objConn.Open "DRIVER=SQLite3 ODBC Driver;  Database=C:\storagedata\Polldata.db3;"

objRecordset.open “Select * from Table_Name”, objConn

objConn.Close

End Sub

Can someone please tell me what changes do I have to make to access an encrypted database.

Thanks in Advance,
Amruth.

2

Hi @achintha454

It looks like you are using Visual Basic, possibly a version for .NET? While SQLCipher is an open source project, that only provides access to the source code of the C library. If you are interested in a turnkey solution for quick integration within your application, you might consider a commercial license to the software which also include private, prioritized support.

Have you already licensed a commercial build of SQLCipher for your project? If not, trials are available upon request here prior to purchase.

3

Yes, we did buy the license.

4

Hi @achintha454

Would you mind reaching out to us directly at support@zetetic.net with some additional details regarding your project and integration, we would be happy to assist you further.

5

Sure. Will do that. Thanks.