Demo project not working

drpeej · Post by **drpeej** » Sat 06 Nov 2010 11:10

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

drpeej · Post by **drpeej** » Sat 06 Nov 2010 11:25

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

drpeej · Post by **drpeej** » Sat 06 Nov 2010 11:47

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

Peter

AndreyZ · Post by **AndreyZ** » Mon 08 Nov 2010 07:39

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