Devart Forums

I am trying to run the Embedded demo and I put the libmysqld.dll in the Embedded folder with the Exe. When I try to run the program, it comes up fine but when I press the Open button I get the following error after the Connect dialog appears and I press Connect:

A call to an mysql_server_init failed
C:\Delphi 7\MyDAC for Delphi 7\Demos\Technology Specific\Embeddeed\data\Ibdata1 - the file exists
C:\Delphi 7\MyDAC for Delphi 7\Demos\Technology Specific\Embeddeed\data\ib_logfile0 - the file exists
C:\Delphi 7\MyDAC for Delphi 7\Demos\Technology Specific\Embeddeed\data\Ib_logfile1 - the file exists

I have not touched the code for this project. Earlier I got errors saying the program could not find the following files: Plugin.frm, Plugin.MYD and Plugin.MYI in the MySQL folder so I created a folder and found the files.

What am I doing wrong? I am using Delphi 7.

Thanks in advance!

Tom Nesler

Hello,

Please try the following:
- remove the data and share directories and the libmysqld.dll library from the Embedded directory;
- copy the data and share directories and the libmysqld.dll library from your MySQL Embedded to the Embedded directory;
- run the MyDAC Embedded demo project and check if any problems persist.

AndreyZ wrote:Hello,

Please try the following:
- remove the data and share directories and the libmysqld.dll library from the Embedded directory;
- copy the data and share directories and the libmysqld.dll library from your MySQL Embedded to the Embedded directory;
- run the MyDAC Embedded demo project and check if any problems persist.

I tried what you asked me to do but it did not fix things.

Here is what I did:
1. I removed the data and share folders.
2. I created a new folder called C:\Embedded and added the compiled program Embedded.exe along with the Delphi files (Embedded.dpr, Main.Pas. etc)
3. I added the libmysqld.dll file to the Embedded folder
4. I added a blank data folder and the Share\English folder with the errmsg.sys as per the documentation on Embedded databases.

The System created a folder called "Test" for the Database (as expected) but it is empty.

The Error messages are same. Still having problems initializing. I presume that the user for this demo is "root" and the password should be left blank.

The System created two log files and a IbData1 file. Is there any way to access the Log files? Perhaps they would be useful?

Thanks for your patience

Tom Nesler

Are you sure you are using the "Share" folder corresponding to the libmysqld.dll version?

Dimon wrote:Are you sure you are using the "Share" folder corresponding to the libmysqld.dll version?

I'm sorry but I have no Idea what you mean... I am using PHP 5.3.8 I created a share folder underneath the "Embedded" folder

C:\Embedded\Share

The libmysqld.dll file is found in the Embedded folder along with the Embedded.exe that I compiled.

I'm not sure where to look to find out where my "Share" folder should be based on the dll's version.

I am sure it is something simple like what you described but I don't see what it is...

Tom Nesler

To work with MySQL Embedded, you need the libmysqld.dll library and the share directory from the same MySQL Embedded version. I've sent you MyDAC Embedded demo with the libmysqld.dll library and the share directory from MySQL Embedded 5.5.20 . Please run this demo, there must be no errors.

AndreyZ wrote:To work with MySQL Embedded, you need the libmysqld.dll library and the share directory from the same MySQL Embedded version. I've sent you MyDAC Embedded demo with the libmysqld.dll library and the share directory from MySQL Embedded 5.5.20 . Please run this demo, there must be no errors.

Can you send me a copy? I usually use server version but now want to investigate using embedded for some project. Thanks.

I got valid email address in profile and if you need I can post also. Thanks.

I've sent you a copy.

Received with thanks!

If you have any questions about using MySQL Embedded, please contact us.

AndreyZ wrote:To work with MySQL Embedded, you need the libmysqld.dll library and the share directory from the same MySQL Embedded version. I've sent you MyDAC Embedded demo with the libmysqld.dll library and the share directory from MySQL Embedded 5.5.20 . Please run this demo, there must be no errors.

Thanks AndreyZ! However, when I received your email it did not contain any attachments... Could you resend it to my Yahoo account?

I apologize for the inconvenience...

Tom Nesler

Sent.

AndreyZ wrote:Sent.

Thanks Andrey! I have received the files and compiled the program successfully. Now the fun begins!

Thanks again!

Tom Nesler

I'm glad I could help. Don't hesitate to contact us if you have any further questions about MyDAC.