Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 2066
Message
De
16/12/2004 13:32:28
 
 
À
15/12/2004 19:13:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
00969271
Message ID:
00969799
Vues:
58
I feel sorry for your sister. She must not have had any pull with the administrator of the network. I worked for the government for seven years and managed a huge system on Novell (I was both the network manager and a programmer then) which started out on Novell 3.11 and moved through all versions eventually to 6.0 Never had a single index corruption in all those years. Seriously, not one. I had little if any memo corruption also. I learned early what optimal settings to use (you can find them here on the UT) and it paid off. I didn't experience index and memo corruption until I started working with apps on peer-to-peer networks in small mom and pop shops on Windows 98/2K/XP systems where the owners change settings on you following someone else's idea of finetuning that they found on the web without realizing the repercussions. What I would sometimes give for the old days! :o)

>We think it's the in memory index corruption because of caching which VFP 8 now reports butVFP7 ignored. We're going to use SYS(1104) in the error handler with a retry on the LOCATE. The description of the problem in earlier threads matches our problem.
>
>My sister managed a big Fox app on a Novell a couple years back - index corruption was a nightmare then for her. My systems were on NT, no problems. She was so jealous! Especially after rebuilding a 3 million record customer table with about 20 tags every night for months.
>
>Thanks Jim
>
>
>>David,
>>
>>Is it possible that there's WRITE cacheing on the server's DB HD?... or even on workstations? I don't know anyone who trusts that stuff and turning it OFF seems to be pretty much universal.
>>
>>I recently had a problem where network adapters had 'sleep mode' set on at factory (all DELL systems). a sudden short-term sleep might do who knows!?!?
>>
>>Finally, long ago and with a different NOS (Novell 3.11) we had daily index corruptions. These were real. We had the most expensive server available at the time, a Tricord model XXX. Turned out it had never been 'certified' for Novell. Changing to a clunky sounding (by comparison) Compaq ??? pentium 90 with 256MB and a 20+ drive RAID array solved that one nicely.
>>
>>One more thing... I wonder if older OS' on workstations might have some compatibility problems with latest storage/locking scheme of 2003 server.
>>
>>good luck
>>
>>
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform