Web Service does not display SQL Data

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nodavies
    #1

    Web Service does not display SQL Data

    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.

    Tags: None
    • nodavies
      #2
      RE: Web Service does not display SQL Data

      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:
      [color=blue]
      > 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.
      >[/color]

        Comment

        • nodavies
          #3
          RE: Web Service does not display SQL Data

          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:
          [color=blue]
          > 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.
          >[/color]

            Comment

            • nodavies
              #4
              RE: Web Service does not display SQL Data

              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:
              [color=blue]
              > 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.
              >[/color]

                Comment

                • nodavies
                  #5
                  RE: Web Service does not display SQL Data

                  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:
                  [color=blue]
                  > 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.
                  >[/color]

                    Comment

                    • hellrazor
                      #6
                      Re: Web Service does not display SQL Data

                      "=?Utf-8?B?bm9kYXZpZXM =?=" <nodavies@discu ssions.microsof t.com> wrote in
                      news:FC3EF0F4-7AE2-447D-A49A-3A6229984B0F@mi crosoft.com:
                      [color=blue]
                      > 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.
                      >[/color]

                      Google is your friend:

                      "login failed" user aspn - Google Search
                      http://www.google.ca/search?num=100&hl=en&q=+%22login+failed%22+user+aspn

                      et+asp+webservi ce+OR+%22web+se rvice%22+OR+web services&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.

                        Comment

                        • hellrazor
                          #7
                          Re: Web Service does not display SQL Data

                          "=?Utf-8?B?bm9kYXZpZXM =?=" <nodavies@discu ssions.microsof t.com> wrote in
                          news:FC3EF0F4-7AE2-447D-A49A-3A6229984B0F@mi crosoft.com:
                          [color=blue]
                          > 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.
                          >[/color]

                          Google is your friend:

                          "login failed" user aspn - Google Search
                          http://www.google.ca/search?num=100&hl=en&q=+%22login+failed%22+user+aspn

                          et+asp+webservi ce+OR+%22web+se rvice%22+OR+web services&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.

                            Comment

                            • nodavies
                              #8
                              Re: Web Service does not display SQL Data

                              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:
                              [color=blue]
                              > "=?Utf-8?B?bm9kYXZpZXM =?=" <nodavies@discu ssions.microsof t.com> wrote in
                              > news:FC3EF0F4-7AE2-447D-A49A-3A6229984B0F@mi crosoft.com:
                              >[color=green]
                              > > 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.
                              > >[/color]
                              >
                              > Google is your friend:
                              >
                              > http://www.google.ca/search?num=100&...d%22+user+aspn
                              > et+asp+webservi ce+OR+%22web+se rvice%22+OR+web services&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.
                              >[/color]

                                Comment

                                • nodavies
                                  #9
                                  Re: Web Service does not display SQL Data

                                  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:
                                  [color=blue]
                                  > "=?Utf-8?B?bm9kYXZpZXM =?=" <nodavies@discu ssions.microsof t.com> wrote in
                                  > news:FC3EF0F4-7AE2-447D-A49A-3A6229984B0F@mi crosoft.com:
                                  >[color=green]
                                  > > 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.
                                  > >[/color]
                                  >
                                  > Google is your friend:
                                  >
                                  > http://www.google.ca/search?num=100&...d%22+user+aspn
                                  > et+asp+webservi ce+OR+%22web+se rvice%22+OR+web services&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.
                                  >[/color]

                                    Comment

                                    Previous template Next
                                    Working...