libmysql.dll ??
lazarus / 16-Databases

----------------------------------------------------------------------
perhen · 2014-11-24 16:50

Hello
I try to use MySQL together with Lazarus, and I have read this
tutorial: http://wiki.lazarus.freepascal.org/SQLdb_Tutorial1
I do have a table with content, I set up a dbConnection
(MySQL56Connection1) and do all other things as explained in the
tutorial.

In code I have written:

procedure TForm1.Button1Click(Sender: TObject);
begin
  SQLQuery1.close;
  SQLQuery1.SQL.Text := 'select * from customer';
  DBConnection.connected := true;
  SQLTransaction1.active := true;
  SQLQuery1.Open;
end;       

Everything works fine here. But why does it work even if I remove
theses two lines:
 DBConnection.connected := true;
  SQLTransaction1.active := true;
?

And why do I get errormessage "Can not load default library
(libmysql.dll or libmysql.dll)" when I try to set the Connected-
poperty to True in the Object Inspector of the DBConnection?  The file
is copied to the folder of all the rest of the lpi, pas and lfm-files.

I'll be thankfull for an answer.

perhen

----------------------------------------------------------------------
exdatis · 2014-11-24 17:06

Please, try search option before post your question:
http://forum.lazarus.freepascal.org/index.php/topic,26543.msg163235.ht
ml#msg163235
http://forum.lazarus.freepascal.org/index.php/topic,24050.msg144403.ht
ml#msg144403
There is so many question about the same problem...