I'm trying to connect to my godaddy database that I set up,
and for some reason the connection string I'm using doesn't work,
it goes to catch when it comes to the con.Open().
here is the connection string and test that I'm using.
loaded the mysql dll.
the usings:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MySql.Data.MySqlClient;
using System.Data;
the code:
private MySqlConnection con;
public DBconnect()
{
con = new MySqlConnection();
con.ConnectionString = "SERVER=xxx.db.xxx.hostedresource.com; DATABASE=xxx; uid=xxx; pwd=xxx;";
}
public bool Tryconnect()
{
try
{
con.Open();
return true;
}
catch
{
return false;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
解决方案If you want to connect to a database remotely, you must enable Direct Database Access when setting it up—you cannot enable it later. For more information, see Why connect remotely to hosting databases? and Creating MySQL or SQL Server Databases for Your Hosting Account.
NOTE: Free hosting accounts cannot enable Direct Database Access. To upgrade your hosting account, see Upgrading Your Hosting Account.