SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,671 questions
Microsoft OLE DB Driver Idle Session KB5040711 Issues
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 62%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Brett R
0
Reputation points
We are using SQL 2019 enterprise and noticed a few products have hundreds of open IDLE sessions left open after the KB5040711 Update for OLE DB Driver.
We have had to roll this back but appears to be a bug. This has occurred over few products using OLE SQL connection. Normally these connections would be closed but are being left in idle connected state. This has never happened before, and is direct result from the OLE Update.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky 25,851 Reputation points2024-08-22T14:11:09.35+00:00 You can post your experiences with that version of OLEDB Driver here:
David Engel from that team will get it to his immediate attention.
-
Brett R 0 Reputation points
2024-08-22T17:27:42.84+00:00 Great thanks I was looking everywhere for this location to report to team.
-
Erland Sommarskog 110.3K Reputation points2024-08-22T21:43:58.46+00:00 Maybe it is a bug. Maybe you have been using the provider in an inappropriate way, but you have been lucky and got away with it.
In what context are you using the OLE DB driver?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Rick Obradors 0 Reputation points2024-09-05T17:36:56.74+00:00 Hi Erland, we just had an internal vulnerability report recommend to install the KB5040711 Update for OLE DB Driver. Are there other reports of issues or concerns by us installing it based on Brett's posting here?
-
Erland Sommarskog 110.3K Reputation points
2024-09-05T20:33:51.17+00:00 I don't have much direct experience of this update. I am sure it has been installed on machines I work on, but I don't if there any applications using the driver on these machines.
But Brett's post is the only report I've seen that claims that there are issues with the update. And as my comments above indicates, I am not sure that there is an issue with the driver as such, but it could be flaw in his code.
Sign in to comment
Sign in to answer