How to fix A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

Aniket kori 20 Reputation points
2023-08-31T05:26:47.01+00:00

Hi,

I am trying to execute OPENROWSET operator but I am getting the following error on the given syntax.

getting error as :- Msg 109, Level 20, State 0, Line 22 A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

also after execution getting disconnected from SQL server .

SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
                'Excel 12.0;Database=C:\Users\aniket\Desktop\Tr.xlsx;HDR=YES;Network=DBMSSOCN;', 
                'SELECT * FROM [Sheet1$]')
SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Anonymous
    2023-08-31T06:22:03.9166667+00:00

    Hi @Aniket kori

    You can check the provider (Microsoft.ACE.OLEDB.12.0) settings in SSMS.

    Server Objects -> Linked Servers -> Providers -> Microsoft.ACE.OLEDB.12.0 -> Properties

    If "Allow inprocess" is checked, the provider code will run within the SQL Server process. This may cause the entire process to shut down.

    For more details, you can refer to this link: https://stackoverflow.com/questions/62423494/getting-a-transport-level-error-when-executing-openrowset.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.