VS2008 C#不能连接mysql5.5,mysql5.7也试过都不行。

[qq_32090585]

本人win10电脑，全部用过了，都有问题，在MySQL Workbench 6.3 CE都可以进入。在控制台用ODBC也成功，不知是不是版本问题，我装的官网mysql5.7.15,在vs2008中不能引用mysql.data.dll,我在网上下了个 mysql.data.dll (6.1.6.0),可以引用，但不能连接，不知是不是什么原因？

using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;

/// <summary>
///MYSQLHelper 的摘要说明
/// </summary>
public class MySqlHelper
{
/// <summary>
/// string server, string database, string login, string pass, int port
/// </summary>
public static String connectionString = "server=localhost;database=mis_db;uid=dbuser;pwd=dbuser;port=3306";

public MySqlHelper()
{

}

#region ExecuteNonQuery
//执行SQL语句，返回影响的记录数
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteNonQuery(string SQLString)
{

using (MySqlConnection connection = new MySqlConnection(connectionString))
{
using (MySqlCommand cmd = new MySqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (MySqlException e)
{
connection.Close();
throw e;
}
}
}
}
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteNonQuery(string SQLString, MySqlParameter[] cmdParms)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
int rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return rows;
}
catch (MySqlException e)
{
throw e;
}
}
}
}
#endregion