Asp.net网页连接远程MySql数据库提示算术运算导致溢出
我用Asp.net做的网页,连接到远程数据库时提示算数运算导致溢出。错误信息如下
算术运算导致溢出。
说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.OverflowException: 算术运算导致溢出。
源错误:
行 51: {
行 52: MySqlConnection con = GetCon();
行 53: con.Open();
[OverflowException: 算术运算导致溢出。]
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) +112
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) +482
MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) +168
MySql.Data.MySqlClient.NativeDriver.Open() +2626
MySql.Data.MySqlClient.Driver.Open() +70
MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +250
MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() +39
MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +372
MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() +198
MySql.Data.MySqlClient.MySqlPool.GetConnection() +125
MySql.Data.MySqlClient.MySqlConnection.Open() +965
DB.reDt(String cmdstr) in d:\My Documents\Visual Studio 2010\WebSites\WeiErShuXue\App_Code\DB.cs:53
Video.Bind_Chapter() in d:\My Documents\Visual Studio 2010\WebSites\WeiErShuXue\Video.aspx.cs:38
Video.Page_Load(Object sender, EventArgs e) in d:\My Documents\Visual Studio 2010\WebSites\WeiErShuXue\Video.aspx.cs:30
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207
--------------------编程问答-------------------- 用Navicat for MySQL可以连接到数据库,但是用VS2010连接数据库时就会提示“算术运算导致溢出”。
VS连接到本机的数据库时可以正常运行,求各位前辈高人指点 --------------------编程问答-------------------- 代码如下
连接字符串:
<connectionStrings>
<add name="SqlServices" connectionString="server=114.80.156.199;User Id=**********;pwd=**********; Persist Security Info=True;database=********;charset=utf8;"/>
</connectionStrings>
public MySqlConnection GetCon()
{
return new MySqlConnection(Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]));
}
public DataSet reDt(string cmdstr)
{
MySqlConnection con = GetCon();
con.Open();
MySqlDataAdapter da = new MySqlDataAdapter(cmdstr,con);
DataSet ds=new DataSet();
da.Fill(ds);
return ds;
}
就是执行到con.open()处报错 --------------------编程问答-------------------- 这个 --------------------编程问答-------------------- 顶一下, --------------------编程问答-------------------- 用VS添加数据库连接也不行,如图,账户密码都对
--------------------编程问答-------------------- 还没人来吗 --------------------编程问答-------------------- 已有该问题的解决方案,请大家移步到 http://www.ilewu.net/forum.php?mod=viewthread&tid=354&page=1&extra=#pid364 http://www.ilewu.net/forum.php?mod=viewthread&tid=354&page=1&extra=#pid364
补充:.NET技术 , ASP.NET