I'm trying to connect to Mongo database from Microsoft SQL Server Management Studio through Linked Servers using Mongo ODBC Driver. Right now I'm testing Easysoft ODBC Driver.
I can connect to the database and can perform some queries. But if I try to execute query which will return a lot of data I receive this error:
Msg 109, Level 20, State 0, Line 2
A transport-level error has occurred when receiving results from the server.
(provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
I receive this error exactly after 31 seconds. I will appreciate any help.
Best Answer
I am not a mongodb developer, but I am not surprised that you had hit the 30 second problem.
See Do you want a timeout? (mLab Blog) for hints.
The socket timeout ideally needs to be set to 0 which means 'forever'.