I am having trouble connecting my pages to a mySQL database on my host's site. The string Im using is as follows:
Dim ConnectionString As String = "Server=server; Database=database; Uid=user; Pwd=password"
I enter all the correct details but it comes back SQL server does not exist or access denied.
Can anybody tell me if I have to declare a mySQL connection or am I simply missing something from the connection string, Im currently using webmatrix to develop using the msde to create SQL database.
richmarham
Member
110 Points
28 Posts
Trouble connecting to mySQL database
Jan 25, 2006 11:33 AM|LINK
I am having trouble connecting my pages to a mySQL database on my host's site. The string Im using is as follows:
Dim ConnectionString As String = "Server=server; Database=database; Uid=user; Pwd=password"
I enter all the correct details but it comes back SQL server does not exist or access denied.
Can anybody tell me if I have to declare a mySQL connection or am I simply missing something from the connection string, Im currently using webmatrix to develop using the msde to create SQL database.
Thanks