prowebinteractive
asked on
need help to create connection to mysql database
Someone please help me create the connection to a mysql server....
http://www.connectionstrings.com/
ASKER
this code does not work..
undefined MySql.Data.MySqlClient.MyS qlConnecti on...
Dim conn As New MySql.Data.MySqlClient.MyS qlConnecti on
Dim myConnectionString As String
myConnectionString = "server=127.0.0.1;" _
& "uid=root;" _
& "pwd=12345;" _
& "database=test;"
Try
conn.ConnectionString = myConnectionString
conn.Open()
Catch ex As MySql.Data.MySqlClient.MyS qlExceptio n
MessageBox.Show(ex.Message )
End Try
undefined MySql.Data.MySqlClient.MyS
Dim conn As New MySql.Data.MySqlClient.MyS
Dim myConnectionString As String
myConnectionString = "server=127.0.0.1;" _
& "uid=root;" _
& "pwd=12345;" _
& "database=test;"
Try
conn.ConnectionString = myConnectionString
conn.Open()
Catch ex As MySql.Data.MySqlClient.MyS
MessageBox.Show(ex.Message
End Try
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THAT PART i KNOW, BUT THE PROGRAM WILL NOT COMPILE
ASKER
am I missing a component, or some sort of driver