MyDAC V5 Support MySQL Embedded Server V5.0.21?

chintatlim · Post by **chintatlim** » Thu 30 Aug 2007 18:32

Antaeus · Post by **Antaeus** » Fri 31 Aug 2007 06:50

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.

chintatlim · Post by **chintatlim** » Fri 31 Aug 2007 08:16

Sorry, Is MySQL Embedded Server Version 5.1.21
MySQL Server Version 5.1.21 include embedded server

Antaeus · Post by **Antaeus** » Fri 31 Aug 2007 12:14

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)