[Mono-list] Access MS Sql Server 2000 from ASP.NET on Linux (Mono)

Shawn Vose mono@programmerforrent.com
Wed, 20 Oct 2004 08:45:16 -0400

I am not sure how dns is handled in mono but if you drop to your command 
line and ping that host(ds12) I am thinking that it will be unresolved 
on your linux machine. You may need to add an entry to your /etc/hosts 
file so that Linux knows who ds12 is.

Shawn Vose

Abdeali Nagarwala wrote:

>Hello All,
>We are trying to connect our MS SQL Server 2000 database which is on Windows 2000 professional, through an ASP.NET application from Linux RedHat using Mono. 
>we are getting fallowing error in the browser
>Server error in '/' application
>Description: Error processing request.
>Error Message: HTTP 500.
>Stack Trace:
>System.Net.Sockets.SocketException: No such host is known
>in <0x000a0> System.Net.Dns:GetHostByName (string)
>in <0x00079> System.Net.Dns:Resolve (string)
>in <0x0015b> Mono.Data.Tds.Protocol.TdsComm:.ctor (string,int,int,int,Mono.Data.Tds.Protocol.TdsVersion)
>in <0x00132> Mono.Data.Tds.Protocol.Tds:.ctor (string,int,int,int,Mono.Data.Tds.Protocol.TdsVersion)
>in <0x0001d> Mono.Data.Tds.Protocol.Tds70:.ctor (string,int,int,int)
>in <0x00081> (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds70:.ctor (string,int,int,int)
>in <0x000ba> Mono.Data.Tds.Protocol.TdsConnectionPoolManager:CreateConnection (Mono.Data.Tds.Protocol.TdsConnectionInfo)
>in <0x00032> Mono.Data.Tds.Protocol.TdsConnectionPool:CreateConnection ()
>in <0x00225> Mono.Data.Tds.Protocol.TdsConnectionPool:GetConnection ()
>in <0x002cc> System.Data.SqlClient.SqlConnection:Open ()
>in <0x0004f> (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlConnection:Open ()
>in <0x00051> TestCSonLnx.WebForm1:Page_Load (object,System.EventArgs)
>in <0x00069> (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
>in <0x00086> System.Web.UI.Control:OnLoad (System.EventArgs)
>in <0x00024> System.Web.UI.Control:LoadRecursive ()
>in <0x00198> System.Web.UI.Page:InternalProcessRequest ()
>in <0x000c2> System.Web.UI.Page:ProcessRequest (System.Web.HttpContext)
>in <0x002eb> ExecuteHandlerState:Execute ()
>in <0x00084> StateMachine:ExecuteState (System.Web.HttpApplication/IStateHandler,bool&)
>------------ Connection String -----------------------
>the Connection String used to connect our database on windows 2000 is   Server=dsl2;
>User ID=dsl2\\administrator;
>Integrated Security=SSPI;
>here dsl2 is name of windows 2000 machine
>I hope this helps you to resolve your problem
>thanking you in advance