Recent Blog ArticlesMost RecentMost LikesPolyBase External Objects in an AlwaysOn Availability Database Problem I was recently helping a customer with an issue where he was using PolyBase external objects in an AlwaysOn Availability Database. After setting up a readable secondary replica, when trying...Re: Generic ODBC external data sources may not work after installing Cumulative Update Hi Anne_Ca, This issue only affects Data Virtualization (PolyBase) ODBC connector functionality. SSIS or ODBC/OLEDB drivers in general are unaffected. Re: Generic ODBC external data sources may not work after installing Cumulative Update Reinaldo - you can put literally anything in that string. It doesn't matter. You could put Driver=blah or Driver=Reinaldo. Literally anything. There just needs to be an entry for Driver key-value pai...Re: Generic ODBC external data sources may not work after installing Cumulative Update Hi Berch1108, I have seen prompting for installation media when uninstalling cumulative updates - that is nothing to be alarmed about. Just be sure that you're uninstalling the update for SQL S...Re: Generic ODBC external data sources may not work after installing Cumulative Update Yes, Jeff, you can check that table and check for any entries in the location column that start with 'odbc://'. Those would be your generic ODBC external data sources. Generic ODBC external data sources may not work after installing Cumulative Update Symptoms After you install SQL Server 2019 CU19 or SQL Server 2022 CU2, external data sources using generic ODBC connector may no longer work. When you try to query external tables that were cr...[Data Virtualization] May need to update Java (JRE7 only uses TLS 1.0) TL;DR - if you have an old Azure Storage account you've been using for PolyBase queries and suddenly start encountering the error "com.microsoft.azure.storage.StorageException: The server encountered...PolyBase Generic ODBC - Error calling: SQLSetDescRec - The driver does not support this function. You may see the following problem when querying a PolyBase external table pointing to a generic ODBC external data source.We have observed this error for three different PolyBase generic ODBC extern...SQL CLR .NET Framework runtime fatal error due to Uneven Number of CPUs Across Processor Groups If you're using SQL CLR, you may have encountered an unexpected SQL Server service termination issue on SQL Servers with a large number of CPUs that are unevenly distributed across the processor grou...Re: PolyBase error - 100001;Failed to generate query plan. Hieriund Are you still experiencing this problem? The only time I've seen it is when PolyBase Engine and SQL Engine are not on same version. Nathan
MicrosoftMicrosoftMicrosoftMicrosoft
