The requested resource is in use

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

    The requested resource is in use

    I got error message "The requested resource is in use. " when access a
    database asp page. I check and see that IUSR should have all the
    rights. It seems that the page doesn't like response.redire ct .

    Please help. Thanks!!!

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • Curt_C [MVP]
      #2
      Re: The requested resource is in use

      Lost me... what does a Response.Redire ct have to do with it?
      How exactly are you accessing this MDB, and did you give CREATE rights to
      the FOLDER that the MDB is in to the IUSR account?

      --
      Curt Christianson
      Owner/Lead Developer, DF-Software
      Darkfalz.com
      https://www.Darkfalz.com



      "eddie wang" <ewang@kmg.co m> wrote in message
      news:uw19XZkzDH A.1760@TK2MSFTN GP10.phx.gbl...[color=blue]
      > I got error message "The requested resource is in use. " when access a
      > database asp page. I check and see that IUSR should have all the
      > rights. It seems that the page doesn't like response.redire ct .
      >
      > Please help. Thanks!!!
      >
      > *** Sent via Developersdex http://www.developersdex.com ***
      > Don't just participate in USENET...get rewarded for it![/color]


        Comment

        • Foo Man Chew
          #3
          Re: The requested resource is in use

          http://www.aspfaq.com/show.asp?id=2356






          "eddie wang" <ewang@kmg.co m> wrote in message
          news:uw19XZkzDH A.1760@TK2MSFTN GP10.phx.gbl...[color=blue]
          > I got error message "The requested resource is in use. " when access a
          > database asp page. I check and see that IUSR should have all the
          > rights. It seems that the page doesn't like response.redire ct .
          >
          > Please help. Thanks!!!
          >
          > *** Sent via Developersdex http://www.developersdex.com ***
          > Don't just participate in USENET...get rewarded for it![/color]


            Comment

            • eddie wang
              #4
              Re: The requested resource is in use

              Here is the code. If I comment out response.redire ct, the busy error
              message will not appear. IUSR has all the right for the folder now.

              <!--#include file=acnOpen.as p-->
              <%
              Dim acn, ars, acd

              set ars = Server.CreateOb ject("ADODB.Rec ordset")
              set acd = Server.CreateOb ject("ADODB.Com mand")


              sSql = "Select * From AdminLogIn Where UserName = '" &
              Trim(Request.Fo rm("UserName") ) & "' And Password = '" &
              Trim(Request.Fo rm("Password") ) & "'"

              set ars = acn.Execute(sSq l)

              if not ars.EOF and not ars.BOF Then
              Session("UserID ") = ars.Fields("Adm inLogInID")
              Session("LogIn" ) = True
              if trim(Request.Fo rm("UserName") ) = "ministers" and
              trim(Request.Fo rm("Password") ) = "fbminister s" then
              Response.Redire ct ("ministries.as p")
              else
              Response.Redire ct ("AdminMain.asp ")
              end if
              else

              Response.Redire ct ("Admin.asp" )
              end if

              ars.Close
              set ars = nothing
              set acn = nothing
              %>

              *** Sent via Developersdex http://www.developersdex.com ***
              Don't just participate in USENET...get rewarded for it!

                Comment

                • Foo Man Chew
                  #5
                  Re: The requested resource is in use

                  > sSql = "Select *

                  Gross. Name your columns. In this case, you could do just as well with
                  SELECT 1 (you're not actually using any of the data anyway).
                  [color=blue]
                  > Where UserName = '" & Trim(Request.Fo rm("UserName") ) & "'[/color]

                  Mmmm, can you say, "SQL injection"? Enter "O'Brien" as the username in the
                  form (without the quotes). Then try a password of "pass'; DROP TABLE
                  floob;'" (again, without the quotes).
                  [color=blue]
                  > if not ars.EOF and not ars.BOF Then[/color]

                  What on earth do you expect BOF to tell you? The following should be
                  sufficient:

                  if not ars.EOF
                  [color=blue]
                  > Response.Redire ct ("ministries.as p")[/color]

                  Could the problem be happening here?
                  [color=blue]
                  > Response.Redire ct ("AdminMain.asp ")[/color]

                  Or here?
                  [color=blue]
                  > Response.Redire ct ("Admin.asp" )[/color]

                  Or here?

                  In other words, maybe ministries.asp and/or AdminMain.asp and/or Admin.asp
                  has code that causes the problem.
                  [color=blue]
                  > ars.Close
                  > set ars = nothing
                  > set acn = nothing[/color]

                  You forgot acn.close


                    Comment

                    • eddie wang
                      #6
                      Re: The requested resource is in use

                      It is working now!!! I checked on the Cache ASP applications based on
                      http://www.aspfaq.com/show.asp?id=2356


                      *** Sent via Developersdex http://www.developersdex.com ***
                      Don't just participate in USENET...get rewarded for it!

                        Comment

                        Previous template Next
                        Working...