PolyBase Error: TCP Provider: An existing connection was forcibly closed by the remote host

Copper Contributor

Dec 22, 2023

Hello Balmukund,

Please help !!

If the source is a local csv file, then I am getting the following error message:

OLE DB provider "MSOLEDBSQL" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "MSOLEDBSQL" for linked server "(null)" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".

Msg 10061, Level 16, State 1, Line 0
TCP Provider: No connection could be made because the target machine actively refused it.

I am using the following syntax to create the external data source:

CREATE EXTERNAL DATA SOURCE MyODBC
WITH 
( 
    LOCATION = 'odbc://localhost',
    CONNECTION_OPTIONS = 'Driver=Microsoft Access Text Driver (*.txt, *.csv);Dbq=F:\data\files\',
    PUSHDOWN = OFF
);

1: Have create ODBC-64 bit DSN,

2: Verified that Polybase service is running.

3: Verified that TCP\IP and Named Pipes are enabled.

4: Verified that the csv file is available

Regards,

Shivangi Gupta

Blog Post

PolyBase Error: TCP Provider: An existing connection was forcibly closed by the remote host