Non-Exclusive Proprietary Locking

Advantage Database Server

In older versions of Advantage, proprietary locking did not open files using an exclusive mode, instead it used a "deny write" open mode. While this would allow non-Advantage applications access to the data files, it could also lead to index corruption. Non-Advantage applications could still lock bytes in the files causing Advantage read and write operations to fail. For this reason the default proprietary open mode was changed. If, however, you require other non-Advantage enabled applications (such as backup software or reporting software) to open files in a shared, read-only mode, this server option is available to revert to older behavior.

For more details on proprietary locking, see Advantage Proprietary Locking.

To turn off the exclusive proprietary locking file open mode, perform one of the following:

For NetWare:

Add the following line in the Advantage Database Server configuration file (ADS.CFG).

NONEXCLUSIVE_PROPRIETARY_LOCKING=1

For Linux:

Add the following line in the Advantage Database Server configuration file (ads.conf).

NONEXCLUSIVE_PROPRIETARY_LOCKING=1

For Windows:

Add the following DWORD using the Registry Editor (REGEDIT.EXE) into the registry, and set its value to 1.

\\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Advantage\Configuration\NONEXCLUSIVE_PROPRIETARY_LOCKING