pyodbc.OperationalError: ('08S01', '[08S01] [Microsoft][ODBC Driver 11 for SQL Server]TCP 提供程序: 远程主机强迫关闭了一个现有的连接。\r\n (10054) (SQLExecDirectW)

[zxj1999]

Please first make sure you have looked at:

• Documentation: https://github.com/mkleehammer/pyodbc/wiki
• Other issues

Environment

To diagnose, we usually need to know the following, including version numbers. On Windows, be sure to specify 32-bit Python or 64-bit:

• Python: 3.6
• pyodbc:
• OS: win 10
• DB: SQL Server
• driver: ODBC Driver 11 for SQL Server

Issue

pyodbc.OperationalError: ('08S01', '[08S01] [Microsoft][ODBC Driver 11 for SQL Server]TCP 提供程序: 远程主机强迫关闭了一个现有的连接。\r\n (10054) (SQLExecDirectW); [08S01] [Microsoft][ODBC Driver 11 for SQL Server]通讯链接失败 (10054)')

pyodbc.OperationalError: ('08S01', '[08S01] [Microsoft][ODBC Driver 11 for SQL Server]通讯链接失败 (0) (SQLExecDirectW)')

use pyodbc Always disconnect in a while，i want to know why?

[v-chojas]

10054, connection reset by peer. Check your network stability?