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

[Shawn Vose]

Me thinks I should put on my glasses nonetheless.  I should hope that 
given my answer they would know which server name they were using 
regard1e55 of my typ05

;-)

Mariano Alarcon wrote:

> do you mean ds12 (as in 12-step program to better coding)
> or dsl2          (with "L" as in look out for those typos)?
>
> Because it is not the same, you know?
>
> Shawn Vose wrote:
>
>> 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.
>>
>>
>> Regards,
>> Shawn Vose
>> http://www.programmerforrent.com
>>
>> 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;
>>> 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
>>>  
>>>
>>
>>
>> _______________________________________________
>> Mono-list maillist  -  Mono-list@lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-list
>>
>