Problem retrieving data from SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am a newbie to both SQL Server and webservices. I have mostly done
programing in Foxpro, VB6, and a little C++, and VB.net. I have been able
to make a simple webservice work but now I am trying to go one step further
and return XML string of a table. I am trying to return the Customer table
of the northwind database. I am creating the webservice on a XP machine and
loading it to a Win 2003 server. The error I am getting is Login failed for
user 'NT AUTHORITY/NETWORK SERVICE'. This is my function
<WebMethod()> _

Public Function GetData() As String

Dim ctest As String, custDS As New DataSet

Me.SqlConnection1.Open()

Me.CustData.Fill(custDS)

Me.SqlConnection1.Close()

ctest = custDS.GetXml()

custDS = Nothing

Return ctest

End Function

If I do the same function in a vb.net app it works, what am I doing wrong?
--
TIA

Altman



.

Relevant Pages

  • Re: How to send String to Webservice
    ... created pipeline that uses the file dis-assemble to convert to XML. ... > I want to be able to pass that XML file to a webservice as a string. ... Yes the WSDL is defined. ...
    (microsoft.public.biztalk.general)
  • Re: How to send String to Webservice
    ... While I agree with Christof completely, if you are determined to do it your ... >> It is converted to an XML file. ... >> I want to be able to pass that XML file to a webservice as a string. ...
    (microsoft.public.biztalk.general)
  • Re: DateTime WebService Discrepancy.
    ... When the datetime is sent by the webservice, ... > Ofcourse I had not even though of just passing a string as a parameter ... > locally and cut out the call to the web service. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Web Services nutzen in Silverlight 2
    ... Herrlich, mein erster Webservice, und das auch noch mit Silverlight :-) ... Public Function Result() As List ... Public Property IDAs Integer ... Public Property Col1As String ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • Re: text gets destroyed
    ... An alternative is to build a proxy yourself using wsdl.exe (in the .NET ... > In the call to my webservice i changed field3 to the following: ... > If you have any explanation on why it cant send the string to a webservice ... >>> Tried to do the messagebox trick just before calling the webservice. ...
    (microsoft.public.dotnet.framework.compactframework)