Re: MYSQL ASP.NET Connecting
You are using a SqlConnection and presumably other objects from the System.Data.SqlClient namespace. To connect to a MySQL database you need to use ODBC and therefore an OdbcConnection and objects from the System.Data.Odbc namespace.
Your connection string should work but if you want to use a DSN the format is:
"DSN=myDsn;Uid=username;Pwd=password;"
where myDSN is the name of your DSN and you change username and password as required.
HTH
DJ
Re: MYSQL ASP.NET Connecting
You'll also need to find out which provider your host supports, because there are several .net providers for MySQL. You can then get your connectionstring from www.connectionstrings.com