connection problem

connection problem

Postby exeter1256@gmail.com » Mon 28 Nov 2005 02:40

Hi ,
I am using MysqlDirect to connect remote Mysql server in My C# application but after 4-5 min I get disconnected and get this error message:
Lost connection to MySQL server during query

does anyone knows how to solve this problem.
thanks
exeter1256@gmail.com
 
Posts: 4
Joined: Tue 01 Nov 2005 02:38

Postby exeter1256@gmail.com » Mon 28 Nov 2005 03:37

I solved the problem ,

if (maincss.dataHandler.getConnction().Ping()==false)
{

}


use ping to check the connection and recreate the connection ,
that is the solution.
exeter1256@gmail.com
 
Posts: 4
Joined: Tue 01 Nov 2005 02:38

Postby rvr » Mon 12 Dec 2005 19:29

But what's the reason you got disconnected in the first place?

RVR
rvr
 
Posts: 2
Joined: Mon 12 Dec 2005 15:10

Postby Serious » Wed 14 Dec 2005 14:11

This issue can be caused by some network problems or by server configuration.
Serious
 


Return to dotConnect for MySQL