• Replies 3 replies
  • Subscribers 581 subscribers
  • Views 303 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
  • That still does not explain why there are 10 connections active after a while. Could it be that your cicode function aborts before it reaches the SQLClose() command? Might be because of a hardware error or a RETURN statement or when SQLClose() is within an IF condition that is not met at that time.
Reply
  • That still does not explain why there are 10 connections active after a while. Could it be that your cicode function aborts before it reaches the SQLClose() command? Might be because of a hardware error or a RETURN statement or when SQLClose() is within an IF condition that is not met at that time.
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.