Embedded MySQL 5 Server

Tom Peiffer · Post by **Tom Peiffer** » Wed 06 Jul 2005 17:37

Hi,

I'm currently doing some tests with the embedded Server and the MyDAC components. Everything works fine when I use the MySQL 4.0 or 4.1 libmysqld.dll, but with the version 5.0 of the MySQL server, I can't get a connection. Is this problem known to someone and maybe there is a workaround.

Ikar · Post by **Ikar** » Thu 07 Jul 2005 12:25

We made an experiment and could establish a connection with the server 5.0.4

Please check if you set correct paths --basedir and --datadir at the server settings.

Guest · Post by **Guest** » Sat 09 Jul 2005 13:06

Hmm.. so maybe I'm doing something wrong... I'm using your demo application embedded.exe, and here is what is written in the my.ini file located under c:\windows

Code: Select all

[Embedded.exe]
datadir=C:/Programme/Borland/Delphi6/MyDac/Demos/Embedded/data
basedir=C:/Programme/Borland/Delphi6/MyDac/Demos/Embedded/

Exactly this configuration works, if I use the libmysqld.dll file from MySQL 4.0 or 4.1, but not with 5.0.6 beta version... Mayme I need to do some more configuration, and you can tell me... Thanks for your support.

Ikar · Post by **Ikar** » Mon 11 Jul 2005 08:39

Below follow three different ways of solving:
- Try to comment these lines
- Try to clear subfolder data
- Copy shared folder form MySQL 5.0 to subfolder demos

Tom Peiffer · Post by **Tom Peiffer** » Mon 11 Jul 2005 17:52

Still no success

I now get an error message

Unknown MySQL datatype (15) (d:\Projects\Delphi\MyDac\Source\MyClasses.pas, Zeile 880)

This folder doesn't even exist on my system.

What exactly do you mean by

- Try to comment these lines

Ikar · Post by **Ikar** » Tue 12 Jul 2005 06:16

> Unknown MySQL datatype (15)

You should download last MyDAC build from crlab site

Tom Peiffer · Post by **Tom Peiffer** » Tue 12 Jul 2005 15:58

I now installed the latest build of version of 3.55, and get the error

"A call to an mysql_server_init failed" !

The version of MyDAC 4 beta, I could not compile my projects under Delphi 6, since the compiled DCU units cannot be read from my Delphi6 SP 2, so I could not perform any test.

Any other suggestions?

PS: Sorry to insist on this point, but I need MySQL 5 indeed, to include views and stored procedures in the DB.

Ikar · Post by **Ikar** » Wed 13 Jul 2005 10:52

> I now installed the latest build of version of 3.55, and get the error
> "A call to an mysql_server_init failed" !

Possible reasons and their solutions:
- At the same machine another local server is running. Check a list of started services.
- Incorrect settings in my.ini. Remove from my.ini sections [Embedded.exe] and [Embedded]

> Any other suggestions?

Could you start usual MySQL 5.0 server?

> The version of MyDAC 4 beta, I could not compile my projects under Delphi 6,
> since the compiled DCU units cannot be read from my Delphi6 SP 2, so I could not
> perform any test.

We compiled MyDAC 3.55 and 4.0 at the same version Delphi 6 UP2

Tom Peiffer · Post by **Tom Peiffer** » Thu 14 Jul 2005 06:58

Ikar wrote:Possible reasons and their solutions:
- At the same machine another local server is running. Check a list of started services.

This is right, but nothing changes if I stop this server. Same error.

Ikar wrote:- Incorrect settings in my.ini. Remove from my.ini sections [Embedded.exe] and [Embedded]

Same

Ikar wrote:Could you start usual MySQL 5.0 server?

Yes

Ikar wrote:We compiled MyDAC 3.55 and 4.0 at the same version Delphi 6 UP2

My Delphi tells me, that CLRClasses unit was compiled with a different version of System.RTLVersion. I don't know, if the other DCU files are OK, since the compiler only gives this single message.

Ikar · Post by **Ikar** » Thu 14 Jul 2005 12:53

Please specify the exact version of MySQL 5.0 that you use.
Is it possible that used libmysqld.dll from another version that standard server?
Do you have new records in errors log in MySQL\Data?

Guest · Post by **Guest** » Thu 14 Jul 2005 18:01

Ikar wrote:Please specify the exact version of MySQL 5.0 that you use.

Version 5.0.6 beta

Ikar wrote:Is it possible that used libmysqld.dll from another version that standard server?

I use the libmysqld.dll file that is installed during setup of MySQL 5.0.6 beta.

You wrote some lines above, that your tests were successful with MySQL 5.0.4 - maybe this is the interesting point. I would like to test ist with this version too, but I would need the corresponding libmysqld.dll file

Ikar wrote:Do you have new records in errors log in MySQL\Data?

What do you mean? MySQL Server 5 ist NOT running. I'm just trying to use the embedded server. With MySQL 5 Server and the MyDAC components, the connection works fine.

Ikar · Post by **Ikar** » Wed 20 Jul 2005 14:08

We tested with MySQL 5.0.9, all works correctly.

> What do you mean? MySQL Server 5 ist NOT running.

Log is written not depending on server type. Quite often, it is the only way to find a reason of the problem with embedded server.

ManUtd · Post by **ManUtd** » Mon 24 Oct 2005 00:33

I am just start using the embedded server using MyDAC version 4 with MySQL Server 5.0.

I cannot even run the demo.
Couple of questions:
1) I cannot find the libmysqld.dll in MySQL folder (it appears in the Adobe folder instead)

2) I copy the demo source code into another folder called:
"C:\Temp\Embedded"
How do I setup the BaseDir and DataDir ?

3) Do I need to setup in the my.ini ?

4) Any instructions/exampls on setting up the TMyEmbConnection properties ?

Ikar · Post by **Ikar** » Mon 24 Oct 2005 12:56

Plase see our answer in http://crlab.com/forums/viewtopic.php?t=2099

OOOPs · Post by **OOOPs** » Wed 23 Nov 2005 13:48

Tom Peiffer wrote: My Delphi tells me, that CLRClasses unit was compiled with a different version of System.RTLVersion. I don't know, if the other DCU files are OK, since the compiler only gives this single message.

I Have This Error TOO. How i can to fix it.