I am using VS 2008.
Looking around on the forums/stack hasn't provided a clear answer on how to use MySQL with a ASP .NET site.
How do I configure a SQLDataSource to use MySQL by using the MySQL Connector NET provider?
I would prefer not to use the ODBC driver – which I can get working. The connector has been added as a reference to the project and appears in the web.config as:
<add assembly="MySql.Data, Version=18.104.22.168, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
And I also attempted to manually create a section under :
<add name="MYSQL" connectionString="Server=localhost;Database=data;Uid=root;Pwd=1234;" providerName="MySql.Data" />
The MySQL Connector version that I have is 22.214.171.124