本文介绍了错误[HY000] [MySQL] [ODBC 5.1驱动程序]无法连接到'localhost'上的MySQL服务器(10048)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

朋友,



我在项目中使用代码时遇到了一些问题。当我试图在mysql中插入大量数据时,实际上出现了问题。如果我添加了大约1000附近的数据然后没有产生任何错误但是当我插入大约5000附近的数据然后给我错误。



错误[HY000] [MySQL] [ ODBC 5.1驱动程序]无法连接到'localhost'上的MySQL服务器(10048)



我正在执行所有程序,所以我的执行页面存在,但我的问题不是解决。



我已经在连接字符串中插入了一些信息,所以我的页面长住了



add name =MySqlConnectionStrconnectionString =Driver = {MySQL ODBC 5.1 Driver}; server = localhost; uid = root; pwd = pwd; database = pwd; option = 0; Connect Timeout = 72000;汇集=真;最大池大小= 72000providerName =System.Data.Odbc



后来



Hi friend,

I have some problem when implimented code in my project.Actually problem occured when i am trying to insert a lot of data in mysql.If i am added data near about 1000 then not produced any error but when i inserted data near about 5000 then give me error.

"ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10048)"

I am doing all the procedure so my execution page live but my problem not solve.

Already i have inserted some information in connectionstring so my page live in long

"add name="MySqlConnectionStr" connectionString="Driver={MySQL ODBC 5.1 Driver};server=localhost;uid=root;pwd=pwd;database=pwd;option=0;Connect Timeout=72000; pooling='true'; Max Pool Size=72000" providerName="System.Data.Odbc""

then later

<httpRuntime executionTimeout="72000" maxRequestLength="4096" shutdownTimeout="360" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100" enableVersionHeader="true"/>





然后我在mypages中插入了server.scripttimeout,并在我的命令方法中写了commandtimeout。所以请告诉我如何解决这个问题的信息。





感谢先进!!



then later i have inserted server.scripttimeout in mypages and also write commandtimeout in my command method.So please give me information how to solve this problem.


Thanks in advanced !!

推荐答案

这篇关于错误[HY000] [MySQL] [ODBC 5.1驱动程序]无法连接到'localhost'上的MySQL服务器(10048)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-13 11:45