Re: Where is Connector/NET Documentation

[Michelle Tay]

Hai,
I am a beginner to the MySQL..I would like to use Connector/Net to link MySQL with VB.Net.
I am using the local host. I don't know why I cant connect to the Database. the error msg state that "Access denied for user 'username'@'localhost'(using password:YES)"

Here is my code:
**************
Imports MySql.data.mySqlClient

Private Sub connectMysql
Dim myConnection As New MySqlConnection
myConnection.ConnectionString = "server=localhost; database=databaseName; uid=username;password=password"

Dim myInsertQuery As String = "INSERT INTO tblStaff (s_id, s_pwd, s_fname, s_lname, s_group) Values(hdyy, 452287, Panda, Cute, Normal)"
Dim myCommand As New MySqlCommand(myInsertQuery)
myCommand.Connection = myConnection

myConnection.Open()

MsgBox("Connection ok")
myCommand.ExecuteNonQuery()
myCommand.Connection.Close()

End Sub


Please help me.. Thank 1st :)


regards