Page 4 of 11
Re: SQLCipher ported to Harbour (Windows)
Posted: Thu Mar 21, 2013 6:03 am
by Hazael
Hello Rathinagiri,
That would be simply great!
For now what I did was to use all the libs, compiler and tools from HMG 3.1.1 (Test 2012-12-02) with your SQLCipher lib and it worked as expected.
Thanks for your tip. Without it I would take a long time to figure it out what was wrong...
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Mar 27, 2013 7:36 am
by Hazael
Hmmm now I found a new problem... does not matter where I build an EXE (Win 7 / Win XP) it will not work on XP at all... It gives an internal (0xc0150002) error.
I am not sure but it seems to be related to the different versions of Libs x Harbour x SQLCipher... could it be? I am using the latest SQLCipher lib by Rathinagiri and the latest HMG 3.1.1.
It works fine in Win 7 but on XP keeps giving that error. I tried in both XP real machine and XP virtual machine.
The solution would be build SQLCipher from scratch? Any comments? Anyone experienced the same problem?
Thanks for any insight.
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Mar 27, 2013 7:48 am
by mol
I get the same error. But, so strange, on some computers with windows XP everything works OK, on some doesn't work...
I've found a solution in the net:
Install .Net Framework 3.5 or later, but I can't test it now.
Try do to it and report, please.
Regards, Marek
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Mar 27, 2013 9:19 am
by Rathinagiri
Might be because HMG 3.1.1 is unicode enabled?
I have installed regional and east asian languages in my XP and it works fine.
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Mar 27, 2013 9:25 am
by Hazael
Hello Marek,
Thank you for jumping in.
Tested using Microsoft Virtual PC 6.0.192.0 and XP SP2 installed there.
I had to first install MS Installer 3.1, reboot, install .NET Framework 3.5.
It worked!
Why? Good question...
Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Mar 27, 2013 11:33 am
by mol
Super info!
You've helped me find solution for my client!

Re: SQLCipher ported to Harbour (Windows)
Posted: Wed Mar 27, 2013 12:32 pm
by Rathinagiri
I am happy that people are using this library.
Re: SQLCipher ported to Harbour (Windows)
Posted: Fri Mar 29, 2013 3:24 pm
by Hazael
Hello Rathinagiri,
I contacted Mr. Billy Gray (Zetetic LLC) that is one of the main developers for SQLCipher library to know about any plan for releasing it for SQLite 3.7.16 and I took the advantage to ask if he would be interested to have some information in his website about your success porting it to HMG.
Well, he was very pleased and interested in it. I will share the whole communication with you below.
So I thought that since you were the person who did the porting that you would like to continue with that. He is asking for HMG logo to add it to the project’s About page. I believe it could help both HMG and SQLCipher.
Follows the communication I had:
On Sun, Mar 24, 2013 at 10:54 AM, Zetetic LLC <
no-reply@wufoo.com> wrote:
Hello,
I would like to know if you would want to add some information on your SQLCipher website about how the HMG (Harbour MiniGUI) project was successful to build it and use such nice tool. There is a step-by-step guide to build it in Windows there.
Here:
viewtopic.php?f=5&t=2275
I thought it could somehow help your project to a bit more known and at the same time to help HMG or even Harbour Project
http://www.harbour-project.org the same way. Both are open source projects. HMG is basically a GUI interface for Harbour.
Thanks
Qatan
And his answer:
From: Team Zetetic
Sent: Thursday, March 28, 2013 5:24 PM
To: ??????????@gmail.com
Subject: Re: SQLCipher [#1287]
Hi Qatan,
The best way to help you get the word out is probably to post to the SQLCipher users mailing list about your integration. Do you have some logo artwork for HMG that you could send us? I'll take a look at adding it to the project's About page.
Thanks!
Billy Gray
I gave him the link to Harbour Project but I didn't give any link to HMG. What link we should direct people to?
https://sites.google.com/site/hmgweb/ is what I thought but maybe this forum?
Here is the SQLCipher users mailing list link:
https://groups.google.com/forum/?fromgr ... /sqlcipher
Do you want to take care of that? I would really appreciate it, if you want of course.
What do you think?
Re: SQLCipher ported to Harbour (Windows)
Posted: Fri Mar 29, 2013 3:36 pm
by Hazael
rathinagiri wrote:Might be because HMG 3.1.1 is unicode enabled?
I have installed regional and east asian languages in my XP and it works fine.
I do not think so... I tried with 3.0.46 and gave me the same error. I had to install .NET Framework 3.5 to solve the problem.
Well, I think that a good way to test is to create a virtual machine of Windows XP Professional SP2 without any update (this one I know does give that error...)
Than compile a program that gives the error, than compile with regresive versions of HMG until one of them works (3.1.1) (3.0.45) (3.0.44)...
That way we would know in which version the problem started and than we could track what changed on that version that created the problem.
That's just an idea.
Re: SQLCipher ported to Harbour (Windows)
Posted: Fri Mar 29, 2013 3:56 pm
by Rathinagiri
It is great to have a contact with the original developer.
I was eager to introduce our success in this regard in the mailing list. Since SQLCipher windows part is not free, I didn't tell anything there.