我有以下课程:
public class MySqlConnectionManager
{
public MySqlConnection Connection { get; set; }
public void OpenConnection()
{
Connection = new MySqlConnection(GetConnectionString());
try
{
Connection.Open();
}
catch (MySqlException exc)
{
switch (exc.Number)
{
case 0:
throw new Exception("Cannot connect to MySQL-server. Please contact administrator.");
case 1045:
throw new Exception("Invalid username/password to connect to MySQL-server. Please correct data.");
default:
throw new Exception("Unknown MySQL-connection error. Code: " + exc.Number);
}
}
}
private string GetConnectionString()
{
string activeDatabaseServer;
string activeDatabaseName;
string activeDatabaseUsername;
string activeDatabasePassword;
#if DEBUG
activeDatabaseServer = DebugDatabaseServer;
activeDatabaseName = DebugDatabaseName;
activeDatabaseUsername = DebugDatabaseUsername;
activeDatabasePassword = DebugDatabasePassword;
#else
activeDatabaseServer = ReleaseDatabaseServer;
activeDatabaseName = ReleaseDatabaseName;
activeDatabaseUsername = ReleaseDatabaseUsername;
activeDatabasePassword = ReleaseDatabasePassword;
#endif
string connectionString = "server=" + activeDatabaseServer + ";uid=" + activeDatabaseUsername + ";pwd=" +
activeDatabasePassword + ";database=" + activeDatabaseName + ";";
return connectionString;
}当调用Connection.Open()时,我会得到一个超时异常。将超时设置为120秒没有帮助。我的调试数据库可以工作(它是本地的)。只有在发布模式下才会得到此异常。但我确信服务器、数据库、用户名和密码的名称是正确的,因为我使用的是来自用php编写的另一个应用程序的相同数据库,在这个应用程序中,一切都很正常。
密码包含“!”、“%”、“*”、“”等特殊字符。或者“@”。这会引起什么麻烦吗?
发布于 2014-06-04 15:22:46
我的代码运行在外部系统上。从外部连接到托管的mysql数据库是不可能的。:(
https://stackoverflow.com/questions/24021459
复制相似问题