October 15, 2018 at 9:10 am
Has anyone had issues with SQL server leaving connections open after running a query on a Progress/Open Edge database?
I have a SQL Server 2016 database connecting to the Progress/Open Edge database via Linked Server. Any time I run any query against the database, SQL does not seem to release the connections. After a few queries, the Progress/Open Edge database will begin refusing connections. I then have to wait a few hours for the connections to finally be cleaned up.
I have tried connecting to the Progress/Open Edge database via MS Access using the exact same ODBC connection and there is no issue. I can run endless queries in MS Access with no issue.
Any ideas?
October 16, 2018 at 8:14 am
JeffMoyer - Monday, October 15, 2018 9:10 AMHas anyone had issues with SQL server leaving connections open after running a query on a Progress/Open Edge database?I have a SQL Server 2016 database connecting to the Progress/Open Edge database via Linked Server. Any time I run any query against the database, SQL does not seem to release the connections. After a few queries, the Progress/Open Edge database will begin refusing connections. I then have to wait a few hours for the connections to finally be cleaned up.
I have tried connecting to the Progress/Open Edge database via MS Access using the exact same ODBC connection and there is no issue. I can run endless queries in MS Access with no issue.
Any ideas?
That's probably the nature of a Linked Server connection. If you need to terminate the connection, then you would need to do so manually, which probably means programmatically. You can't really blame SQL Server for this, either. SQL Server doesn't have this problem. I'd suggest finding a Progress forum, as there would likely be a better chance of someone there having encountered this before. You may also want to look into the Progress documentation on supporting a Linked server connection from SQL Server.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply