Search found 5 matches

by kjteng
Mon Nov 05, 2018 4:54 pm
Forum: Database Related
Topic: Need help on wxsqlite3.4.2.0
Replies: 3
Views: 17441

Re: Need help on wxsqlite3.4.2.0

Thanks for you reply.
by kjteng
Mon Nov 05, 2018 1:09 pm
Forum: Database Related
Topic: wxsqlite3.4.2.0 how to open old encryted database
Replies: 2
Views: 16672

Re: wxsqlite3.4.2.0 how to open old encryted database

Oh yes! "PRAGMA key=" + QuotedStr(tx1Pass.Text) + ";";
Problem solved !
Also thanks for the detailed explanation.
Thank you very much.
by kjteng
Mon Nov 05, 2018 9:38 am
Forum: Database Related
Topic: wxsqlite3.4.2.0 how to open old encryted database
Replies: 2
Views: 16672

wxsqlite3.4.2.0 how to open old encryted database

I have some old database (encryted with AES256 using wxsqlite3.3.5.0.dll) which I want to access after switching to wxsqlite3.4.2.0. According to the documentation, I need to run one of the following (depend on the encryption method used) : SELECT wxsqlite3_config("cipher", "aes256cbc...
by kjteng
Mon Nov 05, 2018 8:18 am
Forum: Database Related
Topic: Need help on wxsqlite3.4.2.0
Replies: 3
Views: 17441

Re: Need help on wxsqlite3.4.2.0

After numerous time of try and error, I think I have found the solution: I have to set the encrypted property of the zConnection to true for version 3.4.2.0 as follows: ZConnection1.Disconnect; ZConnection1.Database := FileNameEdit1.FileName; ZConnection1.Password := edit1.Text'; // change the encry...
by kjteng
Mon Nov 05, 2018 4:37 am
Forum: Database Related
Topic: Need help on wxsqlite3.4.2.0
Replies: 3
Views: 17441

Need help on wxsqlite3.4.2.0

I have downloaded wxsqlite3.4.2.0 and is facing the following problems: 1. I am unable to access database created in the earlier version (3.3.5.0) even if the database is not encrypted (i.e. password = ''). My code (lazarus freepascal, with zeolib database component) is as follows: ZConnection1.Disc...