Web Service does not display SQL Data

[nodavies]

Hi,

I'm looking for some help on an issue that I've been tearing my hair out on
for several days. I have attempted several times to create a web service via
Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke' using the
HTTP GET protocol. However once I click 'Invoke' I receive an error HTTP 500
'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the code for
the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in detail.

[nodavies]

Just as a follow-up: I worte a very similar peice of code but with Web Matrix
as the IDE - same results.

So I'm now thinking that there is something wrong with the configuration of
my IIS 5.0 installation...

"nodavies" wrote:

Hi,

I'm looking for some help on an issue that I've been tearing my hair out on
for several days. I have attempted several times to create a web service via
Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke' using the
HTTP GET protocol. However once I click 'Invoke' I receive an error HTTP 500
'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the code for
the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in detail.

[nodavies]

Just as a follow-up: I worte a very similar peice of code but with Web Matrix
as the IDE - same results.

So I'm now thinking that there is something wrong with the configuration of
my IIS 5.0 installation...

"nodavies" wrote:

Hi,

I'm looking for some help on an issue that I've been tearing my hair out on
for several days. I have attempted several times to create a web service via
Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke' using the
HTTP GET protocol. However once I click 'Invoke' I receive an error HTTP 500
'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the code for
the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in detail.

[nodavies]

Ok, I've got a little further. I unchecked 'Show friendly HTTP error
messages' in IE and I received this message...

Login failed for user TEST1\ASPNET

I figure that somehow there is a ASPNET user that I need to add to a group
somewhere to provide access to the SQL database - but I can't find where...

Any help please?

"nodavies" wrote:

Hi,

I'm looking for some help on an issue that I've been tearing my hair out on
for several days. I have attempted several times to create a web service via
Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke' using the
HTTP GET protocol. However once I click 'Invoke' I receive an error HTTP 500
'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the code for
the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in detail.

[nodavies]

Ok, I've got a little further. I unchecked 'Show friendly HTTP error
messages' in IE and I received this message...

Login failed for user TEST1\ASPNET

I figure that somehow there is a ASPNET user that I need to add to a group
somewhere to provide access to the SQL database - but I can't find where...

Any help please?

"nodavies" wrote:

Hi,

I'm looking for some help on an issue that I've been tearing my hair out on
for several days. I have attempted several times to create a web service via
Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke' using the
HTTP GET protocol. However once I click 'Invoke' I receive an error HTTP 500
'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the code for
the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in detail.

[hellrazor]

"=?Utf-8?B?bm9kYXZpZXM=?=" <no******@discussions.microsoft.com> wrote in
news:FC**********************************@microsof t.com:

Hi,

I'm looking for some help on an issue that I've been tearing my hair
out on for several days. I have attempted several times to create a
web service via Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke'
using the HTTP GET protocol. However once I click 'Invoke' I receive
an error HTTP 500 'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the
code for the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in
detail.

Google is your friend:

http://www.google.ca/search?num=100&...d%22+user+aspn
et+asp+webservice+OR+%22web+service%22+OR+webservi ces&meta=

(unwrap URL)

...which led to this posting:

http://www.dotnetsmart.com/forums/8216/ShowPost.aspx

you may have to do something with Impersonation perhaps.

[hellrazor]

"=?Utf-8?B?bm9kYXZpZXM=?=" <no******@discussions.microsoft.com> wrote in
news:FC**********************************@microsof t.com:

Hi,

I'm looking for some help on an issue that I've been tearing my hair
out on for several days. I have attempted several times to create a
web service via Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke'
using the HTTP GET protocol. However once I click 'Invoke' I receive
an error HTTP 500 'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the
code for the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in
detail.

Google is your friend:

http://www.google.ca/search?num=100&...d%22+user+aspn
et+asp+webservice+OR+%22web+service%22+OR+webservi ces&meta=

(unwrap URL)

...which led to this posting:

http://www.dotnetsmart.com/forums/8216/ShowPost.aspx

you may have to do something with Impersonation perhaps.

[nodavies]

I finally found a solution - I went into SQL Server and created account
access for the ASPNET account - after that everything was fine!
"hellrazor" wrote:

"=?Utf-8?B?bm9kYXZpZXM=?=" <no******@discussions.microsoft.com> wrote in
news:FC**********************************@microsof t.com:

Hi,

I'm looking for some help on an issue that I've been tearing my hair
out on for several days. I have attempted several times to create a
web service via Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke'
using the HTTP GET protocol. However once I click 'Invoke' I receive
an error HTTP 500 'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the
code for the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in
detail.

Google is your friend:

http://www.google.ca/search?num=100&...d%22+user+aspn
et+asp+webservice+OR+%22web+service%22+OR+webservi ces&meta=

(unwrap URL)

...which led to this posting:

http://www.dotnetsmart.com/forums/8216/ShowPost.aspx

you may have to do something with Impersonation perhaps.

[nodavies]

I finally found a solution - I went into SQL Server and created account
access for the ASPNET account - after that everything was fine!
"hellrazor" wrote:

"=?Utf-8?B?bm9kYXZpZXM=?=" <no******@discussions.microsoft.com> wrote in
news:FC**********************************@microsof t.com:

Hi,

I'm looking for some help on an issue that I've been tearing my hair
out on for several days. I have attempted several times to create a
web service via Visual Studio .Net using VB.

The service seems to work fine, displaying the option to 'Invoke'
using the HTTP GET protocol. However once I click 'Invoke' I receive
an error HTTP 500 'The page cannot be displayed'.

I am able to run the 'Hello World' example without problem, and the
code for the SQL data query is built and tuns without error...

Can anyone help? Information on setup/environment can be provided in
detail.

Google is your friend:

http://www.google.ca/search?num=100&...d%22+user+aspn
et+asp+webservice+OR+%22web+service%22+OR+webservi ces&meta=

(unwrap URL)

...which led to this posting:

http://www.dotnetsmart.com/forums/8216/ShowPost.aspx

you may have to do something with Impersonation perhaps.