Microsoft: November updates break ODBC database connections

Microsoft has begun to fix a known problem that affects apps connecting to the ODBC databases after they have installed the Windows Updates for November 2022 Patch Tuesday.

Redmond claims that affected apps may not be able to connect to certain databases using connections with the Microsoft ODBC SQL Server Driver driver.

Microsoft explains that apps using ODBC connections via Microsoft ODBC SQL Server Driver(sqlsrv32.dll), to access databases may not be able to connect after installing the update.

You might also receive errors from your app or the SQL Server.

There are many possible errors that users could see in affected systems.

  • The EMS System experienced a problem. Message: [Microsoft][ODBC SQL Server Driver] Protocol error in TDS Stream.

  • An error occurred in the EMS System. Message from [Microsoft][ODBC SQL Server Driver] An unknown token was received from SQL Server.

This known problem affects both the client and server Windows platforms. It includes Windows 7 SP1 SP2 and Windows Server 2008 SP2 as well as Windows 11 SP1 and Windows Server 2022.

Check if you have apps that aren’t working.

Windows users may use these steps to determine if an app uses ODBC to connect to a data base. This issue is known to affect Windows.

  1. Next, open any applications that use a database. Then click Command Prompt and select Start. Type command prompt and choose it.

  2. Type the following command into the Command Prompt

     tasklist /m sqlsrv32.dll 

Microsoft to its website. It’s working on a solution and will release more information in a future update.

Company is currently investigating , which have been occurring since November 25, also due to last month’s Patch Tuesday Windows Server Updates.

Microsoft had addressed that were caused by the November Patch Tuesday Windows Updates with Emergency Out-of-Band (OOB).