I have a simple test I am trying to run using ADO.net and mono. I create a connection to a SQL Server then attempt to call a stored proc on that connection. When I call Open() on the connection I get the below exception immediately in debug mode. I have set the CommandTimeout to 30 before Open is called on the connection. Since the exception occurs immediately it is not waiting 30 seconds for the timeout to expire which is what it says it did but only in debug mode. If I do this is release mode then it seems to wait and then throw the exception.
I then did NOT set the CommandTimeout and left it to be the default and still the same results. Environment: Windows 2008 R2 SP1 64 bit Visual Studio 2010 SP1 Mono Tools for VS Mono 2.11 master/b32093e (from yesterday compiled in Cygwin) Running test using Mono Tools for VS with a profile setup to the freshly compiled 2.11.x. EXCEPTION ======== Unhandled Exception: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> Mono.Data.Tds.Protocol.TdsTimeoutException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00105] in C:\MonoCompile\cygwin\usr\src\mono\mono\mcs\class\Mono.Data.Tds\Mono.Data.Tds.Protocol\TdsComm.cs:117 --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.Open () [0x00155] in C:\MonoCompile\cygwin\usr\src\mono\mono\mcs\class\System.Data\System.Data.SqlClient\SqlConnection.cs:554 at FunWith40.Program.ExecuteStoredProc[IEnumerable`1] (System.String storedProcName, System.Func`2 readerHandler, Int32 commandTimeoutOverride, System.Data.SqlClient.SqlParameter[] sqlParameters) [0x00047] in FunWith40\Program.cs:179 at FunWith40.Program.spConfig_GetString (System.String domainName, System.String applicationName, System.String itemName) [0x00084] in FunWith40\Program.cs:158 at FunWith40.Program.PerformanceTest (Int32 cyclesPerTest) [0x0000a] in FunWith40\Program.cs:112 at FunWith40.Program.PerformanceTest (Int32 cyclesPerTest, Int32 numberOfTests, Int32 delayBetweenTestsMs) [0x00017] in FunWith40\Program.cs:96 at FunWith40.Program.Main (System.String[] args) [0x00025] in FunWith40\Program.cs:61 Press any key to continue . . . -- View this message in context: http://mono.1490590.n4.nabble.com/ADO-net-issue-with-2-11-master-b32093e-Win32-tp3473994p3473994.html Sent from the Mono - General mailing list archive at Nabble.com. _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
