MySQL 5

killerjohn · Post by **killerjohn** » 24.11.2005, 08:58

Hi!

I'm using Delphi 7 and MySQL 5.0.15, and Zeos supports only MySQL version 4.1, but works fine with 5.0.

I'm in the beginning of a new, large project, and I think optimization is a good thing,

so my question: which version shall support MySQL 5.0 ?

(sorry for my baaaad English

)

killerjohn · Post by **killerjohn** » 24.11.2005, 10:59

another problem:

after opening and and closing a database connection to mysql, my application can't exit. Appliaction.Terminate didn't work - my app remains in memory. And I've this problem only with my computer at home.

somebody know what is this ?

fduenas · Post by **fduenas** » 25.11.2005, 19:14

Yes it seems strange, i have noted this yesterday with mysql 4.1.
ihave noted this, it seems so strange.

I have traced the execution an it freezes when zeos call the Windows's FreeLibrary API call, it seems windows freezes the thread there.

I will do more tests to see how to solve this problem because this is new.
What version of Mysql, and windows version (including service packs) do you have?

killerjohn · Post by **killerjohn** » 26.11.2005, 18:06

Windows XP Professional SP2+all updates
MySQL 5.0.15 (mysqld-nt-max)

it's really strange, because this is a new problem, and only with my home computer

matf · Post by **matf** » 04.03.2006, 13:45

Is there a solution for this Problem ?
I have the same Problem and it almost makes me crazy...

jrmarino · Post by **jrmarino** » 07.03.2006, 21:56

I solved this problem, but I had to build my own mysql 5.0 driver, and in doing so, ended up building a whole new wrapper.

http://seegernet.koolhost.de/zeosforum/ ... .php?t=397

Regardless of what is said above, mysql 4.0, 4.1, and 5.0 all need separate DLL's. The DLL's provided with zeos are old. The 4.1 driver is cobbled together, but works well enough for zeos.

I would say for the time being: Don't rely on the 4.1 driver to work mysql 5.0. If it does, it's more or less a happy accident. At least use the mysql 5.0 library dll, that will probably fix the freezing problem, and may be a good enough long term solution for you.

killerjohn · Post by **killerjohn** » 03.07.2006, 07:34

Yesterday I reinstalled my Windows XP, Delphi 2006, everything, but I've the same problem again....

vanquish · Post by **vanquish** » 06.07.2006, 09:52

Hi.

killerjohn wrote:after opening and and closing a database connection to mysql, my application can't exit. Appliaction.Terminate didn't work - my app remains in memory. And I've this problem only with my computer at home.

I notice this problem after installing a new version of ZoneAlarm.
Uninstalling ZoneAlarm solve the problem.

In ZPlainLoader.pas, I comment in TZNativeLibraryLoader.FreeNativeLibrary

Code: Select all

procedure TZNativeLibraryLoader.FreeNativeLibrary;
begin
//  if (Handle <> 0) and Loaded then   ***ZONEALARM***
//    FreeLibrary(Handle);             ***ZONEALARM***
  Handle := 0;
  Loaded := False;
end;

It's not clean, but it's solve my problem with mySQL 4.1 and ZoneAlarm.

Greatings
Gabriel