protected static String dbServer = "10.169.50.244";
protected static String dbUser = "root";
protected static String dbPwd = "LTE_2011";
protected static String dbName = "cilog_developer";
/// <summary>
/// 获取一个数据库连接对象
/// </summary>
/// <returns>MySqlConnection</returns>
protected static MySqlConnection getConn()
{ try
{
if (conn == null)
{
conn = new MySqlConnection("Server=" + dbServer + ";User Id=" + dbUser + ";Password=" + dbPwd + ";Persist Security Info=True;Database=" + dbName);
} return conn;
}
catch (MySqlException e)
{
Console.WriteLine("数据库连接失败" + e.StackTrace);
} return null;
}
// 查询数据库
String sql = "select filter_dts_url,all_dts_url from download_dts_url";
conn = getConn();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
下面是错误信息: 大概意思是无法连接到数据库
初始化配置...
d:\\test.bat
MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified
MySQL hosts. ---> System.Exception: 引发类型为“System.Exception”的异常。
在 MySql.Data.MySqlClient.NativeDriver.Open()
--- 内部异常堆栈跟踪的结尾 ---
在 MySql.Data.MySqlClient.NativeDriver.Open()
在 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings
)
在 MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.GetConnection()
在 MySql.Data.MySqlClient.MySqlConnection.Open()
在 autodownDts.Program.initConfig() 位置 D:\downDts\autodownDts\autodownDts\P
rogram.cs:行号 169
protected static String dbUser = "root";
protected static String dbPwd = "LTE_2011";
protected static String dbName = "cilog_developer";
/// <summary>
/// 获取一个数据库连接对象
/// </summary>
/// <returns>MySqlConnection</returns>
protected static MySqlConnection getConn()
{ try
{
if (conn == null)
{
conn = new MySqlConnection("Server=" + dbServer + ";User Id=" + dbUser + ";Password=" + dbPwd + ";Persist Security Info=True;Database=" + dbName);
} return conn;
}
catch (MySqlException e)
{
Console.WriteLine("数据库连接失败" + e.StackTrace);
} return null;
}
// 查询数据库
String sql = "select filter_dts_url,all_dts_url from download_dts_url";
conn = getConn();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
下面是错误信息: 大概意思是无法连接到数据库
初始化配置...
d:\\test.bat
MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified
MySQL hosts. ---> System.Exception: 引发类型为“System.Exception”的异常。
在 MySql.Data.MySqlClient.NativeDriver.Open()
--- 内部异常堆栈跟踪的结尾 ---
在 MySql.Data.MySqlClient.NativeDriver.Open()
在 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings
)
在 MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.GetConnection()
在 MySql.Data.MySqlClient.MySqlConnection.Open()
在 autodownDts.Program.initConfig() 位置 D:\downDts\autodownDts\autodownDts\P
rogram.cs:行号 169
链接字符串一行过就可以了,不要那样拼接
给你一个mysql的连接字符串吧。connectionString="Data Source=10.169.50.244;Port=3306;Database=cilog_developer;User ID=root;Password=LTE_2011;Charset=utf8"