Solved

mysql connections

Posted on 2007-03-22
4
3,632 Views
Last Modified: 2008-02-21

We have just installed our application in about 100 user sites.(all remote)

On the whole it is going OK, but a couple of users keep getting this error

Can\'t connect to mySQL server on [server] 10061 .Socket error on connect. WSAGetLastError return 10061($274D)\

Out application is on the local PC, Mysql data on the server.
My application is written is Delphi, using standard components.
0
Comment
Question by:junebrown
  • 2
4 Comments
 
LVL 8

Expert Comment

by:Yuval_Shohat
ID: 18770624
i assume that the application is ran individually on each of the user's sites and all are linked to your mysql data server.
does the error appeares allways in the same computers (same users always getting this error)
then i would try to check what is different with these users. I had a case when a user decided to play with his firewall and deleted all the firewall's rules, thus blocking all data transfer to mysql port 3306. worth checking.
Or does the error randomly appearing everytime with  one or more different users? then maybe the server's limits of connections is worth checking, or maybe the bandwith and so on...
you need to do some debuging and go step by step in order to find out where exactly the problem is.

hope this helps
-=Yuval=-
0
 

Author Comment

by:junebrown
ID: 18779815
I think it is random, as sometimes it work other it does.

Dont think it is a user limit, as they only have 2 or 3 users on it.
and I will go back and check. thanks for these comments.
0
 
LVL 12

Expert Comment

by:str_kani
ID: 18814675
10061 means actively refused. May be check your event log around the same
time to see if mysql died?
0
 

Accepted Solution

by:
junebrown earned 0 total points
ID: 20886418
users cleared it through permissions
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question