问题描述
朋友,
我在项目中使用代码时遇到了一些问题。当我试图在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)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!