[Mono-bugs] [Bug 75164][Wis] New - SqlClient objects should return SqlException instead of SocketException

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by kornelpal at hotmail.com.

http://bugzilla.ximian.com/show_bug.cgi?id=75164

--- shadow/75164	2005-06-06 13:27:12.000000000 -0400
+++ shadow/75164.tmp.3808	2005-06-06 13:27:12.000000000 -0400
@@ -0,0 +1,89 @@
+Bug#: 75164
+Product: Mono: Class Libraries
+Version: unspecified
+OS: All
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: Sys.Data.SqlClient
+AssignedTo: rodrigo at novell.com                            
+ReportedBy: kornelpal at hotmail.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: SqlClient objects should return SqlException instead of SocketException
+
+Example stack trace on Mono:
+
+[System.Net.Sockets.SocketException (0x0000274d): Connection refused]
+    [System.dll] System.Void System.Net.Sockets.Socket::Connect
+(System.Net.EndPoint remote_end)
+    [Mono.Data.Tds.dll] System.Void Mono.Data.Tds.Protocol.TdsComm::.ctor
+(System.String dataSource, System.Int32 port, System.Int32 packetSize, 
+System.Int32 timeout, Mono.Data.Tds.Protocol.TdsVersion tdsVersion)
+    [Mono.Data.Tds.dll] System.Void Mono.Data.Tds.Protocol.Tds::.ctor
+(System.String dataSource, System.Int32 port, System.Int32 packetSize, 
+System.Int32 timeout, Mono.Data.Tds.Protocol.TdsVersion tdsVersion)
+    [Mono.Data.Tds.dll] System.Void Mono.Data.Tds.Protocol.Tds70::.ctor
+(System.String server, System.Int32 port, System.Int32 packetSize, 
+System.Int32 timeout)
+    [Mono.Data.Tds.dll] Mono.Data.Tds.Protocol.ITds 
+Mono.Data.Tds.Protocol.TdsConnectionPoolManager::CreateConnection
+(Mono.Data.Tds.Protocol.TdsConnectionInfo info)
+    [Mono.Data.Tds.dll] Mono.Data.Tds.Protocol.ITds 
+Mono.Data.Tds.Protocol.TdsConnectionPool::CreateConnection()
+    [Mono.Data.Tds.dll] Mono.Data.Tds.Protocol.ITds 
+Mono.Data.Tds.Protocol.TdsConnectionPool::GetConnection()
+    [System.Data.dll] System.Void 
+System.Data.SqlClient.SqlConnection::Open()
+
+Example stack trace (with SqlErrors) on .NET Framework:
+
+[System.Data.SqlClient.SqlError: SQL Server does not exist or access 
+denied. (17)]
+    [.Net SqlClient Data Provider] ConnectionOpen (Connect()).
+[System.Data.SqlClient.SqlException: SQL Server does not exist or access 
+denied.]
+    [system.data.dll] System.Data.SqlClient.SqlInternalConnection 
+System.Data.SqlClient.ConnectionPool::GetConnection(System.Boolean& 
+isInTransaction)
+    [system.data.dll] System.Data.SqlClient.SqlInternalConnection 
+System.Data.SqlClient.SqlConnectionPoolManager::GetPooledConnection
+(System.Data.SqlClient.SqlConnectionString options, System.Boolean& 
+isInTransaction)
+    [system.data.dll] System.Void 
+System.Data.SqlClient.SqlConnection::Open()
+
+Some other example errors originating form network errors:
+
+[System.Data.SqlClient.SqlError: General network error.  Check your 
+network documentation. (11)]
+    [.Net SqlClient Data Provider] ConnectionWrite (WrapperWrite()).
+[System.Data.SqlClient.SqlException: General network error.  Check your 
+network documentation.]
+    [system.data.dll] System.Int32 
+System.Data.SqlClient.SqlCommand::ExecuteNonQuery()
+
+[System.Data.SqlClient.SqlError: General network error.  Check your 
+network documentation. (11)]
+    [.Net SqlClient Data Provider] ConnectionWrite (send()).
+[System.Data.SqlClient.SqlException: General network error.  Check your 
+network documentation.]
+    [system.data.dll] System.Int32 
+System.Data.SqlClient.SqlCommand::ExecuteNonQuery()
+
+[System.Data.SqlClient.SqlError: General network error.  Check your 
+network documentation. (11)]
+    [.Net SqlClient Data Provider] ConnectionRead (recv()).
+[System.Data.SqlClient.SqlException: General network error.  Check your 
+network documentation.]
+    [system.data.dll] System.Data.SqlClient.SqlDataReader 
+System.Data.SqlClient.SqlCommand::ExecuteReader
+(System.Data.CommandBehavior cmdBehavior, 
+System.Data.SqlClient.RunBehavior runBehavior, System.Boolean 
+returnStream)
+    [system.data.dll] System.Int32 
+System.Data.SqlClient.SqlCommand::ExecuteNonQuery()