Page 1 of 1

MyDAC V5 Support MySQL Embedded Server V5.0.21?

Posted: Thu 30 Aug 2007 18:32
by chintatlim
MyDAC V5 Support MySQL Embedded Server V5.0.21?

Posted: Fri 31 Aug 2007 06:50
by Antaeus
Yes, MyDAC does, but, as far as we know, Embedded server of MySQL 5 is pretty unstable. It is not included in the MySQL installation. So, we do not recommend using MySQL Embedded server in production systems.

Posted: Fri 31 Aug 2007 08:16
by chintatlim
Sorry, Is MySQL Embedded Server Version 5.1.21
MySQL Server Version 5.1.21 include embedded server

Posted: Fri 31 Aug 2007 12:14
by Antaeus
MyDAC supports this server, but our users report us that MySQL Embedded server is pretty unstable, especially when working with the InnoDB storage engine. So we recommend using the MySQL Embedded server 4.1, and disabling the InnoDB storage engine. You can disable it in the design-time editor of the TMyEmbConnection component.
As an alternative to MySQL Embedded server, you can try Microsoft SQL Server Compact Edition. This server looks stabler then one from MySQL. Microsoft SQL Server Compact Edition is supported with our SQL Server Data Access components (SDAC)