Web Services ADO Problem

[Terry Ladouceur]

Further to my problem with my HTTP 500 Internal Server Error, I recieve the
following error if I try to run the Service directly on the Web Server that
hosts both the SQL Server and the IIS. The Web Service simply opens a SQL
Connection Runs a Stored Procedure and returns a database. Of course the
error occurs when I try to setup the connection. Any suggestions would be
greatly appreciated as I have no idea of where to proceed from here and it
is of course stopping my development in it's tracks. Thanks

System.Net.WebException: The underlying connection was closed: Unable to
connect to the remote server.
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetResponse(IAsyncRes ult asyncResult)
at System.Net.HttpWebRequest.GetResponse()
at System.Xml.XmlDownloadManager.GetNonFileStream(Uri uri, ICredentials
credentials)
at System.Xml.XmlDownloadManager.GetStream(Uri uri, ICredentials
credentials)
at System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type
ofObjectToReturn)
at System.Xml.XmlTextReader.CreateScanner()
at System.Xml.XmlTextReader.Init()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlReader.MoveToContent()
at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)
at System.Data.DataSet.ReadXml(String fileName)
at TasmisDBSvc.ArmsDBService.GetOfficerList() in
\\server\wwwroot$\TasmisDBSvc\ArmsDBSvc.asmx.vb:li ne 68

Tery Ladouceur