From cb43db6bd1354191732bf503fac84cf3c261bcb5 Mon Sep 17 00:00:00 2001 From: John Anderson Date: Mon, 18 Mar 2013 14:49:28 -0700 Subject: Added disconnect checks for timeout, unable to read, and unable to write --- lib/sqlalchemy/dialects/mssql/pymssql.py | 3 +++ 1 file changed, 3 insertions(+) (limited to 'lib/sqlalchemy/dialects') diff --git a/lib/sqlalchemy/dialects/mssql/pymssql.py b/lib/sqlalchemy/dialects/mssql/pymssql.py index 6f6d3b01f..0754f7f76 100644 --- a/lib/sqlalchemy/dialects/mssql/pymssql.py +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py @@ -85,6 +85,9 @@ class MSDialect_pymssql(MSDialect): def is_disconnect(self, e, connection, cursor): for msg in ( + "Error 20003", # Connection Timeout + "Error 20004", # Read from SQL server failed + "Error 20006", # Write to SQL Server failed "Error 10054", "Not connected to any MS SQL server", "Connection is closed" -- cgit v1.2.1 From eefa4b68f5dce3770d9b95455e9f14439f6bbd72 Mon Sep 17 00:00:00 2001 From: John Anderson Date: Mon, 18 Mar 2013 15:04:30 -0700 Subject: cleaned up errors, only check for connection timeout for now --- lib/sqlalchemy/dialects/mssql/pymssql.py | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'lib/sqlalchemy/dialects') diff --git a/lib/sqlalchemy/dialects/mssql/pymssql.py b/lib/sqlalchemy/dialects/mssql/pymssql.py index 0754f7f76..08e8fca6a 100644 --- a/lib/sqlalchemy/dialects/mssql/pymssql.py +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py @@ -85,9 +85,8 @@ class MSDialect_pymssql(MSDialect): def is_disconnect(self, e, connection, cursor): for msg in ( - "Error 20003", # Connection Timeout - "Error 20004", # Read from SQL server failed - "Error 20006", # Write to SQL Server failed + "Adaptive Server connection timed out", + "message 20003", # connection timeout "Error 10054", "Not connected to any MS SQL server", "Connection is closed" -- cgit v1.2.1