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

[Matthijs ter Woord (meddochat)]

Hi Abdeali   That error is because mono cannot resolve the dsl2 hostname. you should either make that possible or just use the ip address of the windows machine.   matthijs ----- Original Message ----- From: Abdeali Nagarwala To: [EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 12:08 PM Subject: [Mono-list] Access MS Sql Server 2000 from ASP.NET on Linux (Mono) 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; Database=pubs; User ID=dsl2\\administrator; Password=; Integrated Security=SSPI; here dsl2 is name of windows 2000 machine   I hope this helps you to resolve your problem thanking you in advance Abdeali