Sqlite db connection error

VCL
1

I have been trying to build a DB program by using sqlite. I downloaded
‘sqlite-dll-win64-x64-3430200.zip’ from sqlite home page, this is the current sqlite db implementation for windows 64 bit. This zip file just contains a dll and def file. I also downloaded the 32 bit tools file of the sqlite db (sqlite-tools-win32-x86-3430200.zip) . from this zip file I use “sqlite3.exe” (which is 32 bit I think). I copied the sqlite dll file into my Delphi app folder.

Then to create a db file, I used following command in command prompt;
sqlite3.exe sample.db

then I found the following VCL code obtained from embarcaderro site;
In the design time the SQLConnection1’s driver property is set to ‘sqlite’

procedure TForm1.Button1Click(Sender: TObject);
begin
SQLConnection1.Params.Add(‘Database=sample.db’);
try
// Establish the connection.
SQLConnection1.Connected := true;
executeButton.Enabled := true;
outputMemo.Text := ‘Connection established!’;
except
on E: EDatabaseError do
ShowMessage(‘Exception raised with message’ + E.Message);
end;
end;

If I compile the VCL app as 64 bit Windows Application, and run it and press the button1 then the code waits a little bit then the whole app closes. (Without giving any error message)

But if compile the Delphi application as Win32 application everything goes as expected without any error. Connection is established successfully.

Any idea,
Best Regards,

2

I created a quick sample project that just connected to a sqlite db and it worked for both 32-bit and 64-bit. I have not downloaded any dll’s from anywhere.

Is the exe outputs in different directories? Is the sample.db in both the 32-bit and 64-bit directory?

3

It is not a directory problem, since I also tried by supplying the full path to the sample.db (as c:\db\sample.db). Anywayu I did not understand what the problem is. I used firedac and the problem was gone. But this time need help on unicode strings in sqlite.

Thank you