need help to create connection to mysql database

Someone please help me create the connection to a mysql server....  
prowebinteractiveAsked:
Who is Participating?
 
maralansConnect With a Mentor Commented:
That connection string was an example from one of the links.  You need to change the network address, userId, password and database name to connect to your mySql server.
0
 
maralansCommented:
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
prowebinteractiveAuthor Commented:
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
0
 
prowebinteractiveAuthor Commented:
THAT PART i KNOW, BUT THE PROGRAM WILL NOT COMPILE
0
 
prowebinteractiveAuthor Commented:
am I missing a component, or some sort of driver
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.