Hello Everyone,

I have created a a web service for getting and inserting data into oracle server.The web service is working fine from the visual studio, but when i keep the web service in the iis server and run it from the browser it gives a System.NullReferenceException. The server has norton internet security ver7.6 installed in it.Will effect the web service in any way.I am sending the error details.Please help me out.

System.NullReferenceException: Object reference not set to an instance of an object.
   at Oracle.DataAccess.Client.OracleException.get_Messa ge()
   at System.Web.Services.Protocols.ServerProtocol.Gener ateFaultString(Exception e, StringBuilder builder)
   at System.Web.Services.Protocols.ServerProtocol.Gener ateFaultString(Exception e, Boolean htmlEscapeMessage)
   at System.Web.Services.Protocols.HttpServerProtocol.W riteException(Exception e, Stream outputStream)
   at System.Web.Services.Protocols.WebServiceHandler.Wr iteException(Exception e)
   at System.Web.Services.Protocols.WebServiceHandler.In voke()
   at System.Web.Services.Protocols.WebServiceHandler.Co reProcessRequest()

What identity is the web service running under? Can it log in to Oracle? Does that server have the Oracle client and the right tnsnames.ora file? Try logging some messages to see how far it gets.

The web service is working fine in other server with windows 2003 server operating system(which is at our office).But it is not running when i have deplyoed it in the server of the client.In the client machine the same web service is running fine when i run from the visual studio(it is able to send and get data from oracle server).But when i run it from iis server it is giving the above error.

If you're on an early Oracle 9 client you should upgrade to the latest client (the latest 10g client is a supported client to work with a version 9 DB). But if you already have a v10 client the problem is something else.

The early version or the 9 client had a bug in the way it configured NTFS security on the Oracle folder - you can set it yourself to allow the IIS account to have access to all the folders under c:\oracle, but you have to start by figuring out what that account is. You can open a support ticket with Oracle if you need help.

When you run from VS, you're running with adminstrator credentials. You must not open up IIS to run as an administrator!

By the way, this is off topic for this forum, which is on a specific ASP.NET book that uses SQL Server.

Eric