Error 88: Multi User Environment

[netcommerce]

Our website talks to our BTRieve 6.15 via COM and ASP. The BTrieve DB sits on our webserver, and the intranet accesses the BTrieve DB as well.

We get Error 88 or "Record File in use" error very regularly. Have hvae done the MultiEngine (on the server) and SingleEngine (on the workstations) setup and still get these errors.

Does anyone have an idea what to do? Are there more settings for a Multi user environment that we must know about?

Any help, reference to websites, books will be appreciated!!

Thanks in advance!

Leon
leon@netcommerce.co.za

 

[Pervasivite]

It depends on which engine you are using and what the defaults for COM and ASP get set to. Do you have a server engine or are you using two workstation engines sharing data? I work for Pervasive so you know I'm going to suggest that you use the current supported version and that would put our Support department at you disposal along with our Developer Support group which has done quite a bit of ASP and COM programming. Pervasive.SQL 2000i is designed to be a Web database much more than Btrieve 6.15 and since it's supported and we have developers on staff to work with programmers like you it might be a good idea to consider it. I would guess though that whatever interface you are using in COM and ASP is setting the mode to Exclusive, either that or someone has put the server engine into continuous operations mode and it won't come out of it. Here is info from the Status Codes doc.

88: The application encountered an incompatible mode error
The MicroKernel returns this status code in one of the following situations:

If an application opens a file in Exclusive mode, all other applications receive this status code when they try to open the same file in any mode.
If an application opens a file in any mode other than Exclusive, all other applications receive this status code when they try to open the same file in Exclusive mode.
While using the MicroKernel Continuous Operation mode:
You attempted to remove a file from continuous operation, but the file is not in Continuous Operation mode.
You attempted to remove a file from continuous operation, but a different client placed the file into continuous operation.
You attempted to include two files in continuous operation that have the same name but different extensions.
You attempted to include a file in continuous operation, but the file is already in continuous operation.

Hope this helps,
Pervasivite