Kbase P122758: An ODBC application returns error 7511 and error 7612 after running SQL statements in a loop
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/03/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
An ODBC application returns error 7511 and error 7612 after running SQL statements in a loop
An ODBC application runs our of cursors when running SQL statements in a loop
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Cursor not opened (7511) (-20040)
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Number of open cursors exceeds limit (7612) (-20125)
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Option value changed. (0)
Cursors for each SQL statement are being closed properly
The same application worked fine in Progress 9.1x
CAUSE:
Bug# OE00132118
CAUSE:
A cursor for the driver generated "SELECT .... WHERE ROWID =" statement is not being closed.
FIX:
Upgrade the ODBC client to OpenEdge 10.1B.