[Mono-list] ADO.net issue with 2.11 master/b32093e Win32

Rod rodney.foley at lumension.com
Mon Apr 25 15:57:49 EDT 2011


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.


More information about the Mono-list mailing list