Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lots of File is Locked problems with old customers
Message
De
19/02/2014 14:49:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01589062
Message ID:
01594697
Vues:
57
>Thought I would post this for anyone else having this problem. In almost every shop having "file locked" and/or "cursor is read only" the problem was caused by a bad ethernet cable end. Most of my customers are small shops and many have done the cabling themselves. After, at my suggestion, they have a pro come in and check the ethernet switch and cables or they just replace them with pre-made cables the problem is fixed. Error logs go from several a day to nothing.

Thanks for following up - that's an interesting data point.

It seems a bit odd that you would suddenly have several sites reporting that problem. But, maybe it got bad at one site, and when you mentioned it to other sites they said "Oh yeah, we see that sometimes too".

I've seen a few mechanical issues cause cable problems over time:

- cables that are slightly too short, so they are "stretched" to reach between a wall jack and the destination device. This puts stress on the jacks at both ends and on both ends of the cable

- office furniture such as desks rammed up against a wall that has a plugged-in cable. This bends the cable to zero radius at the end (very bad for homemade cables that don't have strain relief) and can also damage the jack

- patch cables run under carpets etc. that are then regularly walked over or rolled over with office chairs, equipment carts etc.

All that assumes the initial installation was OK:

- that the cable is not substandard, there seems to be increasing amounts of counterfeit cable out there
- that the cable was pulled properly and not snagged/torn within walls, ceilings etc.
- that jacks and cable ends were terminated properly (no bad contacts)

One of the most useful things I learned while I worked at an industrial plant is that 80% of electrical problems (read: hardware problems in our business) are caused by bad contacts.

Another thing I've seen "suddenly" start to cause errors is upgrading network infrastructure such as switches from 100Mbit to gigabit (1000Mbit). Cabling and terminations that may have been OK at the low speed may not be sufficient for gigabit - especially if it was an amateur job in the first place.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform