Web Service not working on web server

[Robert Bull]

I have an asp.net app that consumes a web service that is working fine
on my local machine. I have put the service and the app on our web
server. If I make a call to a function in the service that returns a
boolean variable, the communication works fine, but if I try to return
a dataset I get the following error:

'Server was unable to process request. --> Object reference not set to
an instance of an object.'

It looks like the code is choking in the following function:

Public Function GetPersonForACRChange(ByVal lEmployee As Long) As
System.Data.DataSet
Dim results() As Object = Me.Invoke("FunctionName", New Object()
{lEmployee})
Return CType(results(0),System.Data.DataSet)
End Function

Anybody have any ideas. Thanks in advance.

-Rob

 

[Guest]

Hi,

Are you sure the invoke method is working on the web server? I am
assuming that functioinname is quering a database. Maybe the query is
failing because of a security issue?

Ken