Microsoft shares short-term repair for ODBC database connection points

Microsoft has launched a brief repair for a recognized subject impacting Home windows apps utilizing ODBC database connections after putting in the November 2022 Patch Tuesday updates. As the corporate revealed in December, affected apps would possibly fail to connect with databases through connections utilizing Microsoft’s ODBC SQL Server driver.

This recognized subject impacts each consumer and server Home windows platforms, from Home windows 7 SP1 and Home windows Server 2008 SP2 as much as the newest launched Home windows 11 and Home windows Server 2022.

“After putting in this replace, apps that use ODBC connections via Microsoft ODBC SQL Server Driver (sqlsrv32.dll) to entry databases may not join,” Microsoft mentioned.

Moreover, customers would possibly obtain “The EMS System encountered an issue” errors throughout the apps or from SQL Server with “Protocol error in TDS Stream” or “Unknown token obtained from SQL Server” messages. To verify if one among your apps makes use of ODBC connections and is failing to fetch knowledge, you may open it after which run the command from a Command Immediate window (with out the quotes).

Short-term mitigation now out there

Prospects affected by this recognized subject can use one among two strategies to mitigate its affect and revive damaged apps :

  • In case your app is already utilizing or ready to make use of Information Supply Title (DSN) to pick ODBC connections, set up Microsoft ODBC Driver 17 for SQL Server and choose it to be used along with your app utilizing DSN
  • ​In case your app is unable to make use of DSN, the app will should be modified to permit for DSN or to make use of a more moderen ODBC driver than Microsoft ODBC SQL Server Driver (sqlsrv32.dll).

Microsoft mentioned it is at present engaged on a decision, with extra particulars on this subject to be launched in a future replace.The corporate additionally addressed different points triggered after putting in the November Patch Tuesday updates over the past two months.

In November, it issued emergency out-of-band (OOB) updates to repair area controller sign-in failures and different authentication issues. One month later, it addressed an LSASS reminiscence leak subject that led to freezes and restarts on some area controllers after putting in the November Home windows Server updates.

Leave a Reply