Connect AdvancedHMI to MySql Database Error?

[Maxkling]

Is there a reason you are stuck with MySQL? Microsoft SQL express will work very well depending on your needs.

 

[Archie]

According to this:

https://dev.mysql.com/doc/connector-net/en/connector-net-versions.html

The latest .NET connector for MySQL does require .NET 4.5

You may be able to change the main project in AdvancedHMI to target .NET 4.5

 

[lunenburger]

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.

Thanks, I will give that a try...

Our IT dept requested MySql, we have other equipment that uses MySql and Indusoft HMI software to export PLC data.

 

[shawn_75]

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

What you have copied and pasted into the forum as your first post has a space in the word "database" in the SQL connection string. Oddly, when I quote your first post using the forum quote button, that space disappears. Is there by some chance a non-printing character present in the SQL connection string?

EDIT: When quoted in the reply box, the space is not present, when I hit POST, the space returns.

 

[lunenburger]

Yes, the space in database appeared when posting.
It wasn't there in the text i copied... very strange

 

[shawn_75]

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.

 

[Phrog30]

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.

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.

 

[shawn_75]

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.

And I fully agree with you. This is probably an issue with the forum software and not with the code, but this would take all of 30 seconds to rule out.

 

[lunenburger]

I changed mysql server to version 5.7.2 and it shows connected now....
Thanks everyone for the help!