Hi all!

I am trying to connect to a remote MySQL database in a VB.NET application. This database is located on my LAN at the address 192.168.1.2. I am using MySQL Connector/ODBC 3.51 (MyODBC 3.51) for the connection.


The connection string that I am using is the following-

Driver={MySQL ODBC 3.51 Driver};Server=192.168.1.2;Database=mydb;User=root; Password=;Option=3;


The error message that i get is not too intuitive - SystemEventArgs

Has anybody connected to a remote MySQL database in VB.NET?

Isn't it UID instead of User?

Same problem with me in my office LAN ,but Iam using VB6 , the error message is incorrect database name

Then your database name is incorrect, or you do not have rights to it.

Next time, start a new thread, instead of replying to a 3-year old post.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.