Embedded demo not working

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wmaster
Posts: 1
Joined: Sun 20 Sep 2009 08:17

Embedded demo not working

Post by wmaster » Sun 20 Sep 2009 08:51

Hello!

I'm using Delphi 2006 and MyDac 4.3. Embedded demo app tells me error on opening table (LOG-last line):

*******
mysql_embedded, Version: 4.1.7-embedded-log. embedded library
Time Id Command Argument

InnoDB: The first specified data file c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\ibdata1 did not exist:
InnoDB: a new database to be created!

090920 10:46:45
InnoDB: Setting file c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

090920 10:46:45
InnoDB: Log file c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

090920 10:46:46
InnoDB: Log file c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\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

090920 10:46:59 [ERROR] mysql_embedded: Can't find file: 'c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\mysql\time_zone_leap_second.frm' (errno: 22)

090920 10:46:59 [Warning] Can't open and lock time zone table: Can't find file: 'c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\mysql\time_zone_leap_second.frm' (errno: 22) trying to live without them

090920 10:46:59 1 Query SELECT * FROM EMP ORDER BY ENAME

090920 10:46:59 [ERROR] mysql_embedded: Can't find file: 'c:\Dev\CoreLab\Mydac for Delphi 2006\Demos\Win32\Embedded\data\test\emp.frm' (errno: 22)
*******

Any sugestions?

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 21 Sep 2009 09:05

Are you sure you are using the "Share" folder corresponding to the libmysqld.dll version?
If this does not solve the problem try to use another version of MySQL Embedded server, like 4.1.18 or 5.1.22.

Post Reply