• Replies 3 replies
  • Subscribers 581 subscribers
  • Views 304 views
  • Users 0 members are here
Options
Related

Problem "no more handle left" connections to database Microsoft SQL

Sebastian

Has anyone encountered the problem of too many database handles.

We use the cicode SQLcreate and SQLdispose functions when performing stored procedures.
In the parameters of citect.ini we've set up SQLMaxConnections = 0.
In Hardware alams after a while (when in resource monitor watch 10 connections at port SQL) throws an error "no more free handle left" and we must restarting runtime.
Citect Scada 2016
Windows Server 2012 R2
Redundant

Parents
  • I see the [SQL] MaxConnections=0 parameter should allow for unlimited connections. However, the SQLDispose() function's help says "If there is an active SQL connection to a database, the SQL connection has to be closed before disposal." Have you tried calling SQLClose() before SQLDispose()? Also, check if SQLDispose() is returning 0, indicating success. Even if Citect isn't restricting the number of connections, the SQL driver may have a limit.
Reply
  • I see the [SQL] MaxConnections=0 parameter should allow for unlimited connections. However, the SQLDispose() function's help says "If there is an active SQL connection to a database, the SQL connection has to be closed before disposal." Have you tried calling SQLClose() before SQLDispose()? Also, check if SQLDispose() is returning 0, indicating success. Even if Citect isn't restricting the number of connections, the SQL driver may have a limit.
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.