MYSQL ASP.NET Connecting

[shootsnlad]

We have a hosting site a god*ddy. I have a MYSQL database setup and I have the host name and a DSN setup on their site. I am working in VB.NET. I want to connect to the MYSQL database. What is the syntax for that? I tried the following:

Dim mysqlconnect As New System.Data.SqlClient.SqlConnection
mysqlconnect.ConnectionString = "database=MyPlayShop;server=______;UID=____;PASSWORD=___"
mysqlconnect.Open()

Any ideas why it won't open. I'm not sure of the context for opening it with the DSN. But I think the above should connect me?

[dj4uk]

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

[mendhak]

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