My application is running normally then receives error CLI0129E "No more handles".
A call was made to SQLAllocEnv, SQLAllocConnect, or SQLAllocStmt but no more handles are available in the driver.
Resolving The Problem
The resolution is to increase the number of available statement handles.
- Ensure your application calls SQLFreeEnv, SQLFreeConnect, or SQLFreeStmt to free up any handles which are no longer being used in the application.
- Use the How to increase the number of statement handles technote to increase the number of available statement handles.
16 June 2018