Using the Embedded Demo program

tjn006 · Post by **tjn006** » Tue 06 Mar 2012 17:32

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

AndreyZ · Post by **AndreyZ** » Wed 07 Mar 2012 13:00

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.

tjn006 · Post by **tjn006** » Thu 08 Mar 2012 01:19

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

Dimon · Post by **Dimon** » Mon 12 Mar 2012 10:24

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

tjn006 · Post by **tjn006** » Mon 12 Mar 2012 23:30

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

AndreyZ · Post by **AndreyZ** » Tue 13 Mar 2012 11:09

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.

Justmade · Post by **Justmade** » Thu 15 Mar 2012 06:13

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.

AndreyZ · Post by **AndreyZ** » Thu 15 Mar 2012 09:34

I've sent you a copy.

Justmade · Post by **Justmade** » Thu 15 Mar 2012 13:35

Received with thanks!

AndreyZ · Post by **AndreyZ** » Thu 15 Mar 2012 14:16

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

tjn006 · Post by **tjn006** » Thu 15 Mar 2012 23:39

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

AndreyZ · Post by **AndreyZ** » Fri 16 Mar 2012 09:50

Sent.

tjn006 · Post by **tjn006** » Sun 18 Mar 2012 02:16

AndreyZ wrote:Sent.

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

Thanks again!

Tom Nesler

AndreyZ · Post by **AndreyZ** » Mon 19 Mar 2012 09:14

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

Devart Forums

Using the Embedded Demo program

Using the Embedded Demo program

Still having problems -- Embedded Demo