samedi 19 septembre 2015

How to connect to a SQLite Database from a VCL Application?

I am using Delphi XE8 and I'm trying to follow the Embarcadero Tutorial about Connecting to a SQLite Database from a VCL Application.

http://ift.tt/1V3yz7s

After Setting SQLConnection1 driver to Sqlite (screenshot: http://ift.tt/1Mjxile), I'm getting these Debugger Exception Notifications during I debug the program:

First chance exception at $750FB727. Exception class EExternalException with message 'External exception C06D007E'. Process Project5.exe (1948)

First chance exception at $00000000. Exception class $C0000005 with message 'access violation at 0x00000000: read of address 0x00000000'. Process Project5.exe (1948)

First chance exception at $00000000. Exception class $C0000005 with message 'access violation at 0x00000000: read of address 0x00000000'. Process Project5.exe (1948)

This is the code to connect into the SQLite Database (connectButton):

procedure TForm6.connectButtonClick(Sender: TObject);
begin
  SQLConnection1.Params.Add('Database=C:\Users\Wennie\Documents\SQLite Connection');
  try
    SQLConnection1.Connected := true;
    executeButton.Enabled := true;
    outputMemo.Text := 'Connection Established';
  except
    on E : EDatabaseError do
      ShowMessage('Exception raised with message' + E.Message);
  end;
end;

Aucun commentaire:

Enregistrer un commentaire