Hello,
I wonder if anyone can help?
I've written a Microsoft SSIS package to export data from two Progress databases (10.2 and 11.3) that connects via an ODBC 11.3 driver to export data into SQL Server.
However, the Progress administrator contacted me to let me know that on several occasions the SSIS package has created too many connection to the Progress db and they've needed to restart the Progress server to kill all the connections.
From a Progress perspective, is it possible to limit the number of connections a client can make to the database, or similar, to prevent swamping Progress with connection calls?
Many thanks,
Hologram
(ps I originally posted this to the data servers and ODBC forum but perhaps it is more relevant here in the administration forum - apologies for the double post.)
I wonder if anyone can help?
I've written a Microsoft SSIS package to export data from two Progress databases (10.2 and 11.3) that connects via an ODBC 11.3 driver to export data into SQL Server.
However, the Progress administrator contacted me to let me know that on several occasions the SSIS package has created too many connection to the Progress db and they've needed to restart the Progress server to kill all the connections.
From a Progress perspective, is it possible to limit the number of connections a client can make to the database, or similar, to prevent swamping Progress with connection calls?
Many thanks,
Hologram
(ps I originally posted this to the data servers and ODBC forum but perhaps it is more relevant here in the administration forum - apologies for the double post.)