Re: NEW INFO ADDED - IIS 7.0 and web service. Publishing from VS 2008 not working

Leo Tang - MSFT — Fri, 17 Jul 2009 03:34:18 GMT

Hi,

How do you initialize the rootWebConfig? If you are going to obtain configuration information from the application in which your code resides, you can use the static method. It looks like this:
Dim conn As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("PortalConnectionString").ConnectionString)

Actually, this is an ASP.Net issue.

NEW INFO ADDED - IIS 7.0 and web service. Publishing from VS 2008 not working

coreymas — Tue, 14 Jul 2009 12:48:40 GMT

Hello everyone.

I have IIS7 installed and i have used the publish feature from VS2008 to publish a web service to the server.

The web service works when i run it through VS2008... but when i try to test it via URL on the IIS server i get a Generic 500 error. I am able to see the service and the method... send the method parameters etc but when I click on the invoke button i get the 500 error.

My web service method accesses a SQL Server instance and it is using a SQL Authentication connection.

I am guessing that this is a security/configuration issue.. but i do not know where to start looking to fix this.

Edit more info

This is the error I am getting (which is confusing because i am not getting this in VS2008

System.NullReferenceException: Object reference not set to an instance of an object.
at PortalWebService.PortalWebService.VerifyStudentLogin(String UserName, String Password, Int32 LoginType) in D:\Projects\PortalWebService\PortalWebService\PortalWebService\PortalWebService.asmx.vb:line 19

Line 19 in my code is my connection string line (if i can trust the line numbering scheme in VS2008

Dim conn As New SqlConnection(rootWebConfig.ConnectionStrings.ConnectionStrings("PortalConnectionString").ConnectionString)

And yes this string does exist in my WebConfig.

I Have narrowed this down a bit... when i use a connection string in a web config file it fails... but if i hard code the string in the VB code it works..... why is it having trouble accessing/reading the web config file of my application?

Any help would be appreciated.

Corey

IIS7 - General

Re: NEW INFO ADDED - IIS 7.0 and web service. Publishing from VS 2008 not working

NEW INFO ADDED - IIS 7.0 and web service. Publishing from VS 2008 not working