Limiting Connections To Progress Database

Status
Not open for further replies.

Hologram

New Member
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
 
Status
Not open for further replies.
Top