mysql 5.5 / libmysql.dll couldnt be loaded
lazarus / 16-Databases

----------------------------------------------------------------------
Roque · 2014-10-15 12:50

HI , I´m trying to do a simple app using mysql ,  I have installed
mysql on win7 32  already tryied to copy libmysql.dll from C:\Program
Files\MySQL\MySQL Workbench 6.2 CE to C:\Windows\System32 and also 
tryied to copy libmysql.dll from  C:\Program Files\MySQL\MySQL Server
5.5\lib to C:\Windows\System32  but still get the same error ..
libmysql.dll couldnt be loaded/ found

Thank you
Roque

----------------------------------------------------------------------
minesadorada · 2014-10-15 14:05

Try copying libmysql.dll to the same folder as your
application/project

----------------------------------------------------------------------
Roque · 2014-10-15 14:47

thank you now .. can´t run a query the error says the dataset is
inactive ...  it inactive because i can´t open/ active  de query

I get the message that the query is closed  and get the inactive error
on SQLQuery1.First;  


procedure TForm1.Button1Click(Sender: TObject);
var
msg: String;
erro :Boolean;
begin
  erro:=false;
   msg:='ok ';
  MySQLConn.Connected:=true;
  if MySQLConn.Connected  then
     SQLTransaction1.Active:=true
  else
  begin
    erro:=true;
    msg:='MySQLConn not connected .!';
  end;

  if erro=false then
  begin
      if SQLTransaction1.Active then
        SQLQuery1.Active:=true
      else
      begin
       erro:=true;
       msg:='SQLTransaction1 not active .!';
         end;
  end;

  if erro=false then
  begin
      if not SQLQuery1.Active then
     begin
      erro:=true;
      msg:='SQLQuery1 not active ...!';
     end;
  end;

  if (erro) then
   MessageDlg('Error',msg ,mtError,[mbOK],0);


   SQLQuery1.First;
end;

----------------------------------------------------------------------
minesadorada · 2014-10-15 14:53

Just a tip:

If the original problem (can't load dll) is solved, then mark your
first post (Solved) and start a new topic with your new problem.  It
makes it easier and faster to get an answer.

----------------------------------------------------------------------
Roque · 2014-10-15 15:12

ok , but it will lose the "problem history" ...

----------------------------------------------------------------------
Roque · 2014-10-15 15:13

... where is that magic "solved" button ?

----------------------------------------------------------------------
minesadorada · 2014-10-15 15:35

Quote from: Roque on October 15, 2014, 05:13:45 pm... where is that
magic "solved" button ?
In your original post, click the 'Modify' button and edit the title.

I suggested a new topic because your new problem seems unrelated to
the original one, so the topic history could be misleading.

Just trying to help...

----------------------------------------------------------------------
fengyun · 2014-10-25 13:08

Copy libmysql.dll to path of your project,And Copy libmysql.dll to
path of lazarus

----------------------------------------------------------------------
exdatis · 2014-10-25 13:10

Set environment variable -> path(system->advanced system settings...)
path of 'bin' folder.

----------------------------------------------------------------------
BigChimp · 2014-10-25 13:16

Quote from: exdatis on October 25, 2014, 03:10:31 pmSet environment
variable -> path(system->advanced system settings...) path of 'bin'
folder.
Exactly. That's the easiest way of doing this on a development system:
you won't end up with a huge amount of copies of the same dll for each
Lazarus program that uses a database...