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

[Mariano Alarcon]

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
>

-- 
Mariano Alarcón
ITC Soluciones