Solved

mysql connections

Posted on 2007-03-22
4
3,626 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
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 tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

777 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