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

See more:

ASP.NET

MySQL

C#3.5

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"/>

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 !!