Microsoft repairs ODBC connection problems caused by November Updates

After installing the Patch Tuesday November 2022 updates, Microsoft fixed a problem that affected Windows apps connecting to ODBC databases.

The issue affects both the client and server Windows platforms. This includes Windows 7 SP1 & Windows Server 2008 SP2 as well as Windows 11 / Windows Server 2022.

Microsoft stated today that the Patch Tuesday update addresses “a known problem that affects apps using Microsoft Open Database Connectivity, (ODBC), SQL Server Driver (sqlsrv32.dll to connect to database.”

The connection may fail. The app might give you an error, and the SQL Server might send an error to your computer.

Redmond explained in December that impacted applications might not be able to connect to certain databases after Microsoft installed the November Patch Tuesday updates.

You can test if apps using ODBC connections are failing to fetch data by launching them. Next, run “tasklist /m SQLlsrv32.dll”, which will open a Command Prompt (without quotes).

Also available: Temporary mitigation

Two methods can be used by customers affected by this issue to reduce its effects and restore the apps that have been damaged:

• Install if your app uses or is able to use Data Source Name to select ODBC connections.
• Your app may not be able to access DSN. The app must either be modified or use a different ODBC driver that Microsoft ODBC SQL Server Driver(sqlsrv32.dll).

Microsoft today stated that “if the workaround has been implemented, you should continue to use the configuration.”

The Patch Tuesday update in November also caused other issues. These included , as well as due to an LSASS leak.

Redmond also on Windows 10 after installing the KB5021233 Update released Tuesday, December Patch Tuesday.