473,320 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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.redirect .

Please help. Thanks!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
5 3773
Lost me... what does a Response.Redirect 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
www.Darkfalz.com
"eddie wang" <ew***@kmg.com> wrote in message
news:uw**************@TK2MSFTNGP10.phx.gbl...
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.redirect .

Please help. Thanks!!!

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

Jul 19 '05 #2
http://www.aspfaq.com/show.asp?id=2356

"eddie wang" <ew***@kmg.com> wrote in message
news:uw**************@TK2MSFTNGP10.phx.gbl...
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.redirect .

Please help. Thanks!!!

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

Jul 19 '05 #3
Here is the code. If I comment out response.redirect, the busy error
message will not appear. IUSR has all the right for the folder now.

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

set ars = Server.CreateObject("ADODB.Recordset")
set acd = Server.CreateObject("ADODB.Command")
sSql = "Select * From AdminLogIn Where UserName = '" &
Trim(Request.Form("UserName")) & "' And Password = '" &
Trim(Request.Form("Password")) & "'"

set ars = acn.Execute(sSql)

if not ars.EOF and not ars.BOF Then
Session("UserID") = ars.Fields("AdminLogInID")
Session("LogIn") = True
if trim(Request.Form("UserName")) = "ministers" and
trim(Request.Form("Password")) = "fbministers" then
Response.Redirect ("ministries.asp")
else
Response.Redirect ("AdminMain.asp")
end if
else

Response.Redirect ("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!
Jul 19 '05 #4
> 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).
Where UserName = '" & Trim(Request.Form("UserName")) & "'
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).
if not ars.EOF and not ars.BOF Then
What on earth do you expect BOF to tell you? The following should be
sufficient:

if not ars.EOF
Response.Redirect ("ministries.asp")
Could the problem be happening here?
Response.Redirect ("AdminMain.asp")
Or here?
Response.Redirect ("Admin.asp")
Or here?

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


You forgot acn.close
Jul 19 '05 #5
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!
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Aaron | last post by:
IIS 5.0 is throwing out "The requested resource is in use." for any site that uses ASP - HTML is executing fine. I have tried re-installing scripting, latest MDAC, and all my hotfixes are up to...
2
by: Aprochko | last post by:
Attempting to access outlook from C# .NET ASP app. Have added reference to COM Microsoft Outlook 11 Object Library. Have included using System.Runtime.InteropServices; using System.Web.Mail;...
2
by: Craig | last post by:
Hello, I recently installed project server onto a new server (the server is an all in one box that hosts the database (MSDE) and Sharepoint as well as project server). When I attempt to load the...
1
by: John Lenehan | last post by:
Hi, I've just upgraded our intranet server (production) from Win2K to Win2K3. After the upgrade asp works fine on the root and lower level directories, but any virtual directory returns http: 500-...
0
by: Chris Davoli | last post by:
ERROR - The requested resource is in use. I have tried everything to serve up ASP pages on my local machine, but can't seem to fix this error. Environment is Win XP Professional, SP2 Tried:...
1
by: msdnbuddy | last post by:
Sorry for the multiple post but did not know where exactly this belonged. I am getting an error message - The requested resource is in use on Windows Server 2003. I have tried check and...
2
by: Brent Burkart | last post by:
I am trying to send an email using SMTP server through IIS. I am recieving the following error. Access is denied. Description: An unhandled exception occurred during the execution of the...
3
by: engwar | last post by:
I've seen references to this error on-line but the fixes listed haven't helped me. I'm getting the error 'The Requested Resource is in Use' when I attempt to access a classic asp page on IIS on...
3
by: Dale | last post by:
I have a very simple ASP page that when I try and access it, I get the following error: The requested resource is in use. I went through the event viewer and noticed the system log is...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.