Lesson Learned #215: Hands-On-Labs: Communication link failed error message using ODBC.

We used to have cases where our customer faced the following error messages like following:

• ERROR [08S01] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host.
• ERROR [08S01] [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure

In this video below we going to provide us some insights about it. 

Why this issue happens?

• Application or network issue at client level that closed unexpectedly the connection to the database

How to find the issue?

• Application Error messages: mainly followed by client driver names or protocols (ODBC/ TCP)

How to Fix the issue?

• Look for network issues.
• Check performance on target/application server
• Implement the retry-logic at connection and command execution.

In this video we will cover scenarios causing error - Communication link failure

Enjoy!