MySQL.sym error in Embedded mySQL

[ausgen]

Whenever I run the embedded mysql demo the following error message is returned under build 57.0.43 & 44 with both D2007 & D2009.
'Project Embedded.exe raised exception class Exception with message 'A call to an mysql_server_init failed
C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\mysql.sym - The system cannot find the file specified'.
I am getting the same error in a prototype application that I am putting together. Any help would be appreciated.
Dennis

[Dimon]

Please specify the exact version of your Embedded server.

Also make sure that you have privileges to create files in the Embedded\data and Embedded\data\test directories.

[ausgen]

The MySQL version is 5.1.30 and files ib_logfile0, ib_logfile1 & ib_data1 plus folder TEST created successfully. The log created when the demo is executed is as below.

InnoDB: The first specified data file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ibdata1 did not exist:
InnoDB: a new database to be created!
090114 0:17:19
InnoDB: Setting file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090114 0:17:19
InnoDB: Log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090114 0:17:20
InnoDB: Log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created

[Dimon]

I could not reproduce the problem.
Please try to set the MySQLEmbDisableEventLog variable to True. This varible is declared in the MySqlApi unit.
If it doesn't solve the problem, please try to use another version of MySQL Embedded server (e.g. 4.1.18 ).

[ausgen]

Works fine under libmysqld.dll 4.1.22, fails with 4.0.18 and 5.0.xx

[ausgen]

Setting the MySQLEmbDisableEventLog variable to True does not resolve the issue with embedded server 5.1.x.

[Dimon]

I still can not reproduce the problem.
It is possible, it is a bug of MySQL Embedded server but not MyDAC.

[suathd]

replace the errmsg.sys file (which is under C:\Users\Public\Documents\Devart\MyDAC for XXXX\Demos\TechnologySpecific\Embedded\share\english) with your errmsg.sys file (which is in your share folder)

good luck