Kbase 34396: Error 7872 When Connecting To SQL-92 Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P4396
FACT(s) (Environment):
Windows NT 4.0
Windows 2000
Progress 9.1D
Progress 9.1C
SYMPTOM(s):
Error 7872 when connecting to SQL-92 database
Failure to acquire exclusive schema lock for DDL operation. (7872)
The connection is refused
CAUSE:
A user has an exclusive lock on the Schema of the Database. For example, updating a table or field from the Data Dictionary will lock the entire Schema.
FIX:
The user modifying the Schema should Commit the Transaction. This will release the schema lock and a database connection can then be made.