Kbase 15245: Record lock problems when using ODBC driver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Record lock problems when using ODBC driver
When using the Progress ODBC driver with certain applications that do
not unload the OID after a read from the database, records will remain
locked until the OID is shutdown. The default behavior for SQL
connections with ODBC is to keep records in a shared-lock state.
This can be a problem with these applications, or for a user writing
their own C code to connect over ODBC. The solution to this problem
is simply adding the -NL parameter to the OID connection parameters.
In the manual this is listed as -nl so you must be sure that the
customer has this parameter in caps (-NL).
Progress Software Technical Support Note # 15245