Operational Defect Database
BugZero found this defect 340 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2312800
Fixes an issue where external data sources that use the generic ODBC connector may not work after you install SQL Server 2019 CU19 or later versions. You may encounter the following scenarios: 1. When you try to query an external table that was created before you install this fix on a generic ODBC data source, and the CONNECTION_OPTIONS argument uses a DSN parameter without the Driver keyword, you receive the following error message: Msg 7320, Level 16, State 110, Line <LineNumber> Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". Object reference not set to an instance of an object. 2. If you try to create a new external table, you receive the following error message: Msg 110813, Level 16, State 1, Line <LineNumber> Object reference not set to an instance of an object. Note: Before you apply this fix, you can uninstall SQL Server 2019 CU19 or later versions, or add the Driver keyword to the CONNECTION_OPTIONS argument as a workaround. For more information, see Generic ODBC external data sources may not work after installing Cumulative Update.
Last update date:
6/15/2023
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
Affected releases:
build lower than 15.0.4316.3
Fixed releases:
15.0.4316.3
Description:
Fixes an issue where external data sources that use the generic ODBC connector may not work after you install SQL Server 2019 CU19 or later versions. You may encounter the following scenarios: 1. When you try to query an external table that was created before you install this fix on a generic ODBC data source, and the CONNECTION_OPTIONS argument uses a DSN parameter without the Driver keyword, you receive the following error message: Msg 7320, Level 16, State 110, Line <LineNumber> Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". Object reference not set to an instance of an object. 2. If you try to create a new external table, you receive the following error message: Msg 110813, Level 16, State 1, Line <LineNumber> Object reference not set to an instance of an object. Note: Before you apply this fix, you can uninstall SQL Server 2019 CU19 or later versions, or add the Driver keyword to the CONNECTION_OPTIONS argument as a workaround. For more information, see Generic ODBC external data sources may not work after installing Cumulative Update.
