[Mono-dev] Problems connecting to MS SQL with C# and Mono

[muppetboy]

Hi,

Cheers for the responses.  I forgot to mention that I'm testing under
Windows, although I will be deploying under Linux.  I've been compiling via
Vis Studio, and testing it under mono and the clr.  

Running with the --debug option, the exception is:
Unhandled Exception: System.Net.Sockets.SocketException: Connection reset by
pee
r
in [0x00047] (at
C:\cygwin\tmp\scratch\mono-1.1.15\mcs\class\System\System.Net.S
ockets\Socket.cs:1527) System.Net.Sockets.Socket:ReceiveFrom_nochecks
(System.By
te[] buf, Int32 offset, Int32 size, SocketFlags flags, System.Net.EndPoint
remot
e_end)
in [0x00054] (at
C:\cygwin\tmp\scratch\mono-1.1.15\mcs\class\System\System.Net.S
ockets\Socket.cs:1446) System.Net.Sockets.Socket:ReceiveFrom (System.Byte[]
buf,
 System.Net.EndPoint remote_end)
in [0x0003c] (at
C:\cygwin\tmp\scratch\mono-1.1.15\mcs\class\System\System.Net.S
ockets\UdpClient.cs:287) System.Net.Sockets.UdpClient:Receive
(System.Net.IPEndP
oint remoteEP)
in [0x000a4] (at
C:\cygwin\tmp\scratch\mono-1.1.15\mcs\class\System.Data\System.
Data.SqlClient\SqlConnection.cs:958)
System.Data.SqlClient.SqlConnection+SqlMoni
torSocket:DiscoverTcpPort ()
in [0x00009] (at
C:\cygwin\tmp\scratch\mono-1.1.15\mcs\class\System.Data\System.
Data.SqlClient\SqlConnection.cs:627)
System.Data.SqlClient.SqlConnection:Discove
rTcpPortViaSqlMonitor (System.String ServerName, System.String InstanceName)
in [0x00089] (at
C:\cygwin\tmp\scratch\mono-1.1.15\mcs\class\System.Data\System.
Data.SqlClient\SqlConnection.cs:571)
System.Data.SqlClient.SqlConnection:ParseDa
taSource (System.String theDataSource, System.Int32 thePort, System.String
theSe
rverName)
in [0x000b0] (at
C:\cygwin\tmp\scratch\mono-1.1.15\mcs\class\System.Data\System.
Data.SqlClient\SqlConnection.cs:517)
System.Data.SqlClient.SqlConnection:Open ()

in <0x000dc> GADatabase.GADatabaseLog2:.ctor (System.String
ServerAndInstanceNam
e, System.String UserName, System.String PassWord, System.String Database)
in <0x00071> MessagePassingTest2.Program:test (System.String whichOne)
in <0x000b2> MessagePassingTest2.Program:Main (System.String[] args)

Hope this makes more sense!

Thanks again,

Simon
--
View this message in context: http://www.nabble.com/Problems+connecting+to+MS+SQL+with+C-+and+Mono-t1663529.html#a4508930
Sent from the Mono - Dev forum at Nabble.com.