Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.)


Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.)

Description: Again this error occurred due to slow network connection or bad network configuration. For example, when we try to connect a SQL Server through application, and the request taking so much for the output.  The networking layers will bubble this error to SQL Server which will present to us as provider: TCP Provider, error: 0 – The semaphore timeout period has expired.

Solution: Nothing related to code logic, just check the network connections are working properly or the server is up and running. Contact your Network Administrator.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s