Devart Forums

I have downloaded a trial version of MyDAC for Delphi7 and cannot get the Demo project to work.

When I try to create the database I get the following error:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = INNODB' at line 10"

If I use the MySQL query browser to create it using InstallDemoObjects.sql I get the same error. The database schema seems to be only partly created as a result.

I am using MySQL server 5.5

Peter

I have just realised that it is probably because I am running MySQL 5.5 which is not a full release.

I will try 5.1

Peter

Just to confirm - I installed MySQL 5.1 and it now works fine

Peter

It is good to see that this problem has been solved. Feel free to contact us if you have any further questions about MyDAC.