Devart Forums

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.

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.

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 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.

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

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

> Unknown MySQL datatype (15)

You should download last MyDAC build from crlab site

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.

> 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

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.

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?

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.

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.

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 ?

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

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.