Connect AdvancedHMI to MySql Database Error?

Phrog30 said:

This isn't a solution, but just to get your feet wet I would roll back on MySQL to 5.7 and see what you get. In my opinion there really isn't anything in 8 that you need right now.

Click to expand...

lunenburger said:

Here is the vb code that I have in so far:




Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim MySqlConn As MySqlConnection

MySqlConn = New MySqlConnection
MySqlConn.ConnectionString = "server=localhost;userid=root;password=Splash123;database=database"

Try
MySqlConn.Open()
MessageBox.Show("Connected")
MySqlConn.Close()

Catch ex As MySqlException
MessageBox.Show(ex.Message)
Finally
MySqlConn.Dispose()

End Try

End Sub

End Class

Click to expand...

shawn_75 said:

I'm not sure how you'd insert a non-printing character in a string in Visual Studio without seeing it, but I'd delete the string and type it back in just to be sure.

Click to expand...

Phrog30 said:

It sounds like we already established his code works. It's a .net framework version issue. He said he built a project that worked, until he set .net to version 4, then it didn't. Archie also pointed out the MySQL connector requires 4.5.

Click to expand...