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:
VB Code:
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?




Reply With Quote