Were any Windows updates applied since it last worked? How about patches to security or virus software?

And replying to myself once again....
 
It appears that the setting at fault is pervasive auto reconnect. I actually had SPXII disabled on some of the machines still and it all works so the only setting really changed is auto reconnect. I have no idea why that would lock up the database access.

Quote from Lynn_Pantic on 11/10/08 at 21:16:27:

 
 
<Gets out a wipe and wipes Lynn's glasses> There.... It's mentioned in my original post and in the sig line of all my posts. (I'm just giving you a hard time!)
 
I'm using Pervasive workgroup 5 user. I'd like to know the specifics too! I cannot believe that setting auto reconnect on could possibly do this. However, that seems to be the only change between when it used to work, then when it didn't work, then when it did again. As such I have to believe that it's the cause. I just cannot figure out how. I suppose I could fire up a network packet tracer and do more testing but I'd have to do that on a weekend or after hours. Personally I'd rather just send a 900 pound gorilla to tickle the stuffing out of the people responsible for PervasiveSQL and forget about ever trying auto reconnect.