Troubleshooting
Problem
This document provides a possible cause of message SQL7049.
Resolving The Problem
This document provides a possible cause of message SQL7049.
A Microsoft Visual Basic application that is connecting using ODBC fails with message SQL7049 - An internal object limit has been exceeded. The reason code is 1, which indicates that the maximum number of stored procedures with open result sets has been exceeded. The application calls the same stored procedure repeatedly within the same job. The application does not close cursors.
The open result set cursor limit is 256. The error can be resolved by calling the stored procedure in a few different jobs, or by calling the SQLCloseCursor from the client.
Historical Number
385254696
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1015447