While “Patch Tuesday” updates are intended to provide security patches for Windows, they can often lead to major problems. Patch Tuesday” for Windows 11 and Windows 10 and Windows Server caused problems with applications due to an ODBC SQL Server driver error bug.
Microsoft says affected users receive application errors or errors from SQL Server, such as “EMS system encountered a problem” and “Message: [Microsoft][ODBC SQL Server Driver] TDS Stream in protocol error” or “Message: [Microsoft][ODBC SQL Server Driver] Unknown token received from SQL Server.
Now, after the holidays, Microsoft has finally released a solution to the problem.
To alleviate this issue, you can do one of the following.
"If your application is already using or can use Data Source Names (DSNs) to select ODBC connections, install Microsoft ODBC Driver 17 for SQL Server and select it to use with applications that use DSNs. Note: It is recommended to use the latest version of Microsoft ODBC Driver 17 for SQL Server, as it is more compatible than Microsoft ODBC Driver 18 for SQL Server with applications currently using an older version of the Microsoft ODBC SQL Server driver (sqlsrv32. dll). dll) for your application. If your application is unable to use DSN, you will need to modify your application to allow DSN or use a newer ODBC driver than the Microsoft ODBC SQL Server driver (sqlsrv32.dll)."
Microsoft says it is working to resolve the issue.
