Polybase - Enforce TCP/IP Protocol
Hello, We know Polybase service in SQL server by default makes use of shared memory protocol to connect SQL server (local). I would like to know if there is any way we can change or force the connections to make use of TCP / IP protocol. Any help would be appreciated.
PolyBase Error: TCP Provider: An existing connection was forcibly closed by the remote host
In this blog we are sharing details about an issue which can be seen while querying external table created in SQL 2019 with data source pointing to SQL Server 2014. The error message which comes back is “TCP Provider: An existing connection was forcibly closed by the remote host”
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 external data sources, but could happen for any generic ODBC external data source.SQL 2019 PolyBase: Fractional Truncation Issue When Using Data Virtualization in Azure Data Studio
My colleague Liwei Yin recently blogged about how to use the Data Virtualization extension in Azure Data Studio for creating PolyBase external tables for Oracle data sources. If you've done any work in this area and have Oracle tables that utilize columns with date datatype, you may have run into this issue.How can I use Excel from SQL Server 2019 with PolyBase?
I want to know How can I use Excel from SQL Server 2019 with PolyBase? which ODBC driver string do I need to use for connecting Excel file with External Data Source? and anyone can do it? Reference: Configure PolyBase to access external data in SQL Server
