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

Abdeali Nagarwala Abdeali Nagarwala" <a_nagarwala@rediffmail.com
20 Oct 2004 10:08:51 -0000


 This is a multipart mime message


--Next_1098266931---0-203.199.83.31-24692
Content-type: text/html;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<P>=0AHello All,<BR>=0AWe are trying to connect our MS SQL Server 2000 data=
base which is on Windows 2000 professional, through an ASP.NET application =
from Linux RedHat using Mono. <BR>=0Awe are getting fallowing error in the =
browser<BR>=0A<BR>=0AServer error in '/' application<BR>=0ADescription: Err=
or processing request.<BR>=0A<BR>=0AError Message: HTTP 500.<BR>=0A<BR>=0AS=
tack Trace:<BR>=0A<BR>=0ASystem.Net.Sockets.SocketException: No such host i=
s known<BR>=0Ain &lt;0x000a0&gt; System.Net.Dns:GetHostByName (string)<BR>=
=0Ain &lt;0x00079&gt; System.Net.Dns:Resolve (string)<BR>=0Ain &lt;0x0015b&=
gt; Mono.Data.Tds.Protocol.TdsComm:.ctor (string,int,int,int,Mono.Data.Tds.=
Protocol.TdsVersion)<BR>=0Ain &lt;0x00132&gt; Mono.Data.Tds.Protocol.Tds:.c=
tor (string,int,int,int,Mono.Data.Tds.Protocol.TdsVersion)<BR>=0Ain &lt;0x0=
001d&gt; Mono.Data.Tds.Protocol.Tds70:.ctor (string,int,int,int)<BR>=0Ain &=
lt;0x00081&gt; (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.=
Tds70:.ctor (string,int,int,int)<BR>=0Ain &lt;0x000ba&gt; Mono.Data.Tds.Pro=
tocol.TdsConnectionPoolManager:CreateConnection (Mono.Data.Tds.Protocol.Tds=
ConnectionInfo)<BR>=0Ain &lt;0x00032&gt; Mono.Data.Tds.Protocol.TdsConnecti=
onPool:CreateConnection ()<BR>=0Ain &lt;0x00225&gt; Mono.Data.Tds.Protocol.=
TdsConnectionPool:GetConnection ()<BR>=0Ain &lt;0x002cc&gt; System.Data.Sql=
Client.SqlConnection:Open ()<BR>=0Ain &lt;0x0004f&gt; (wrapper remoting-inv=
oke-with-check) System.Data.SqlClient.SqlConnection:Open ()<BR>=0Ain &lt;0x=
00051&gt; TestCSonLnx.WebForm1:Page_Load (object,System.EventArgs)<BR>=0Ain=
 &lt;0x00069&gt; (wrapper delegate-invoke) System.MulticastDelegate:invoke_=
void_object_EventArgs (object,System.EventArgs)<BR>=0Ain &lt;0x00086&gt; Sy=
stem.Web.UI.Control:OnLoad (System.EventArgs)<BR>=0Ain &lt;0x00024&gt; Syst=
em.Web.UI.Control:LoadRecursive ()<BR>=0Ain &lt;0x00198&gt; System.Web.UI.P=
age:InternalProcessRequest ()<BR>=0Ain &lt;0x000c2&gt; System.Web.UI.Page:P=
rocessRequest (System.Web.HttpContext)<BR>=0Ain &lt;0x002eb&gt; ExecuteHand=
lerState:Execute ()<BR>=0Ain &lt;0x00084&gt; StateMachine:ExecuteState (Sys=
tem.Web.HttpApplication/IStateHandler,bool&amp;)<BR>=0A<BR>=0A<BR>=0A<BR>=
=0A------------ Connection String -----------------------<BR>=0Athe Connect=
ion String used to connect our database on windows 2000 is&nbsp;  Server=3D=
dsl2;<BR>=0ADatabase=3Dpubs;<BR>=0AUser ID=3Ddsl2\\administrator;<BR>=0APas=
sword=3D;<BR>=0AIntegrated Security=3DSSPI;<BR>=0A<BR>=0Ahere dsl2 is name =
of windows 2000 machine<BR>=0A&nbsp; <BR>=0AI hope this helps you to resolv=
e your problem<BR>=0A<BR>=0Athanking you in advance <BR>=0A<BR>=0AAbdeali=
=0A</P>=0A<br><br>=0A<A target=3D"_blank" HREF=3D"http://clients.rediff.com=
/signature/track_sig.asp"><IMG SRC=3D"http://ads.rediff.com/RealMedia/ads/a=
dstream_nx.cgi/www.rediffmail.com/inbox.htm@Bottom" BORDER=3D0 VSPACE=3D0 H=
SPACE=3D0></a>=0A
--Next_1098266931---0-203.199.83.31-24692
Content-type: text/plain;
	charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello All,=0AWe 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. =0Awe are getting fallowing error in the browser=0A=0AS=
erver error in '/' application=0ADescription: Error processing request.=0A=
=0AError Message: HTTP 500.=0A=0AStack Trace:=0A=0ASystem.Net.Sockets.Socke=
tException: No such host is known=0Ain <0x000a0> System.Net.Dns:GetHostByNa=
me (string)=0Ain <0x00079> System.Net.Dns:Resolve (string)=0Ain <0x0015b> M=
ono.Data.Tds.Protocol.TdsComm:.ctor (string,int,int,int,Mono.Data.Tds.Proto=
col.TdsVersion)=0Ain <0x00132> Mono.Data.Tds.Protocol.Tds:.ctor (string,int=
,int,int,Mono.Data.Tds.Protocol.TdsVersion)=0Ain <0x0001d> Mono.Data.Tds.Pr=
otocol.Tds70:.ctor (string,int,int,int)=0Ain <0x00081> (wrapper remoting-in=
voke-with-check) Mono.Data.Tds.Protocol.Tds70:.ctor (string,int,int,int)=0A=
in <0x000ba> Mono.Data.Tds.Protocol.TdsConnectionPoolManager:CreateConnecti=
on (Mono.Data.Tds.Protocol.TdsConnectionInfo)=0Ain <0x00032> Mono.Data.Tds.=
Protocol.TdsConnectionPool:CreateConnection ()=0Ain <0x00225> Mono.Data.Tds=
.Protocol.TdsConnectionPool:GetConnection ()=0Ain <0x002cc> System.Data.Sql=
Client.SqlConnection:Open ()=0Ain <0x0004f> (wrapper remoting-invoke-with-c=
heck) System.Data.SqlClient.SqlConnection:Open ()=0Ain <0x00051> TestCSonLn=
x.WebForm1:Page_Load (object,System.EventArgs)=0Ain <0x00069> (wrapper dele=
gate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,=
System.EventArgs)=0Ain <0x00086> System.Web.UI.Control:OnLoad (System.Event=
Args)=0Ain <0x00024> System.Web.UI.Control:LoadRecursive ()=0Ain <0x00198> =
System.Web.UI.Page:InternalProcessRequest ()=0Ain <0x000c2> System.Web.UI.P=
age:ProcessRequest (System.Web.HttpContext)=0Ain <0x002eb> ExecuteHandlerSt=
ate:Execute ()=0Ain <0x00084> StateMachine:ExecuteState (System.Web.HttpApp=
lication/IStateHandler,bool&)=0A=0A=0A=0A------------ Connection String ---=
--------------------=0Athe Connection String used to connect our database o=
n windows 2000 is   Server=3Ddsl2;=0ADatabase=3Dpubs;=0AUser ID=3Ddsl2\\adm=
inistrator;=0APassword=3D;=0AIntegrated Security=3DSSPI;=0A=0Ahere dsl2 is =
name of windows 2000 machine=0A  =0AI hope this helps you to resolve your p=
roblem=0A=0Athanking you in advance =0A=0AAbdeali
--Next_1098266931---0-203.199.83.31-24692--