Object variable not net

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

netbari@hotmail.com - 06 Feb 2006 15:09 GMT

I created a web-service on my local web server. I call a method from my
ASP.NET app to return a dataset from the pubs db in SQL Server 7.0.
I receive this error message 'object variable not set.
However, this will work if I call a method with the same signature and
the same code from a component.
I step through my code in the web service and the db connection is
opened successfully.

Can anyone help?
Thanks

netbari

Reply to this Message

Patrice - 06 Feb 2006 15:51 GMT

The first step would be to find out which object is nothing/null. For
example you could add debug code to perform this check as it looks like you
have a different behavior whne you step throught your code from the IDE....

Signature

Patrice

> I created a web-service on my local web server. I call a method from my
> ASP.NET app to return a dataset from the pubs db in SQL Server 7.0.
[quoted text clipped - 8 lines]
>
> netbari

Reply to this Message

catalin.tomescu@gmail.com - 06 Feb 2006 18:51 GMT

Check your DB connection string. If you have integrated security to SQL
under ASP.NET will fail because your web pages run under IIS account
(ASP.NET local account) and most probably this is not a SQL valid
login.

Hope this helps.

Catalin

Reply to this Message

Object variable not net

Free Magazines