Mysql oledb connection string

[sengupta_amit]

I cannot enter a connection string in the Mygeneration ide default settings for database without specifying a 'Provider=MysqlProv' parameter.
Where does one download this provider. Is there a way to specify a non oledb connection string for mysql in doodads

[dnparsons]

For MySQL server 4.x or 5.x, be sure to select MYSQL2 in Driver dropdown.

If you are using MyGeneration 1.2.0.7 or earlier, you will need to copy MySQL Connector/NET 5.0.x MySql.Data.dll (available on the MySQL downloads page) to the MyGeneration program folder first.

MyGeneration 1.3.0.3 ships with MySQL Connector/NET 5.1.4, but there are still some issues recognizing foreign keys.

[sengupta_amit]

Thank you. worked like a charm.