远程mysql C＃winforms发生致命错误 [英] Fatal error occurred remote mysql C# winforms

问题描述

我在使用C＃Winform的.net应用程序VS2008中遇到错误。我的数据库远程Mysql-Cpanel。第一次，如果我连接那里没有问题。连接几分钟后laster命令执行错误时遇到致命错误。如果我关闭表单并重新打开它的工作。经过测试这么多时间我发现注意到了。请帮助我，我现在没有选择。如果任何人有这类问题的答案，请附上错误日志请帮助我

I face an error in my .net application VS2008 with C# Winform. My database Remote Mysql-Cpanel. First time if i connected there s no issue. after connected few minutes laster Fatal error encountered during command execution error occur.if i closed form and reopen its working. After testing so much time i found noting.please help me i am out of option now.i attach the error log if any one have an ans for this type of problem please help me

if (T.ConOpen() == true)
                    {
                        Boolean EntryStatus = false;
                        using (MySqlCommand cmd1 = new MySqlCommand("select * from logindetails", con))
                        {
                            using (MySqlDataReader dr1 = cmd1.ExecuteReader()) // Error Occured Here
                            {
                                while (dr1.Read())
                                {
                                    string UserNameTest = T.DecryptDetails(dr1[2].ToString());
                                    string PasswordTest = T.DecryptDetails(dr1[3].ToString());

                                    if ((String.Equals(UserNameTest, UserNameText.Text)) && String.Equals(PasswordTest, PasswordText.Text))
                                    {
                                        ValidationT_MSACCESS.LoginStatus = true;
                                        ValidationT_MSACCESS.Type = T.DecryptDetails(dr1[4].ToString());
                                        ValidationT_MSACCESS.UserNameDetails = T.DecryptDetails(dr1[1].ToString());

                                        EntryStatus = true;

                                        MessageBox.Show("Successfully Login!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                        this.Close();
                                        break;
                                    }
                                }
                            }
                        }

错误：



命令执行期间遇到致命错误。



错误代码：-2147467259





这是我的连接字符串：



server = xxxx;数据库= xxxxx_testing; UID = xxxxx_test; pwd = *****;转换为零datetime = True; charset = utf8



请大家尽快给我解决这个问题的解决方案



我尝试了什么：



i尝试设置net_write_timeout = 99999

和connection pooling = false

Error:

"Fatal error encountered during command execution."

Error code :-2147467259


this is my connection string:

server=xxxx; database=xxxxx_testing; uid=xxxxx_test; pwd=*****;convert zero datetime=True;charset=utf8

please anyone tel me the solution for this problem as soon as possible

What I have tried:

i tried set net_write_timeout=99999
and connection pooling=false

推荐答案

请参阅 80004005 - Google搜索 [ ^ ]，并检查一下正在服务器上发生。

See 80004005 - Google Search[^], and check what is happening on the server.

这篇关于远程mysql C＃winforms发生致命错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！