Good day, i have a windows forms desktop application i built using c#. I need to connect it to an online database hosted on a server.
this is my connection string
the user name and password are that of the user that i created when creating the database online but when i try connecting, i get a "cannot connect to the specified MySQL database" error. meanwhile, i have added my computer's IP address to the cpanel to allow remote database connection and also the port 3306 has been opened for my database. Please can you tell me what i am missing?
Not sure what ODBC driver you are using but try to use not a standard MySQL driver.
I found a guide for installation and connection of other MySQL ODBC driver ODBC driver installation guide
If you have problems with this guide write directly to their support. I did and it worked just fine.