Link to home
Start Free TrialLog in
Avatar of prowebinteractive
prowebinteractive

asked on

need help to create connection to mysql database

Someone please help me create the connection to a mysql server....  
Avatar of maralans
maralans

Avatar of prowebinteractive

ASKER

this code does not work..

undefined  MySql.Data.MySqlClient.MySqlConnection...

       Dim conn As New MySql.Data.MySqlClient.MySqlConnection
        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.MySqlException
            MessageBox.Show(ex.Message)
        End Try
ASKER CERTIFIED SOLUTION
Avatar of maralans
maralans

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
THAT PART i KNOW, BUT THE PROGRAM WILL NOT COMPILE
am I missing a component, or some sort of driver