I've been having the following problem with the Pervasive 9.5 engine: when having multiple inserts to the same table from different clients (for example 3 computers with the Pervasive Client connected to a computer with the Pervasive Server) the engine hangs and I am forced to reboot the server.
Could this be a server configuration problem, a problem related to the table in question or could it be something else?
What is the exact version of PSQL you are using? The easiest way to tell is to look at the version of the W3ODBCEI.DLL.
Second, what happens if you run the INSERT statement through the Pervasive COntrol Center rather than your application?
I've never heard of the engine crashing or hanging in the situation you describe.
Also, is there anything in the PVSW.LOG file on the client or server?
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.