Record and Table Locking

Database Connectors for ODBC supports record locking for multi-user systems, as long as your ODBC driver supports record locking. To complement your driver’s locking method, Database Connectors for ODBC can initiate three locking sequences:

You specify which type of locking you want to use with the configuration file variable, A_ODBC_LOCK_METHOD. However, if your driver doesn’t support locking, Database Connectors for ODBC by itself cannot provide locking.

Record locking with ODBC drivers is a semi-random activity. Different ODBC drivers have different capabilities and even implement the same capabilities in different ways. For this reason, you will have to do some experimentation to determine which locking method to specify for A_ODBC_LOCK_METHOD. Only through trial and error will you be able to determine which method will lock records in the most efficient way for your particular ODBC driver.