I'm running a stored procedure that inserts a record into a table then returns the Identity field value. I've done this kind of thing plenty of times in the past, but I'm obviously doing something wrong this time..
I've tested the Stored Proc in QA and it works fine. The SQL code runs OK in ASP (iAffected = 1 which shows the record is inserted), but when I try to query the resulting recordset, I get an error:
"Item cannot be found in the collection corresponding to the requested name or ordinal. " Code:
Is there a way to get the last requested page from the server?I created a custom 404 asp and would like idealy to log the broken link. I would settle for the page that the link was on. Is there a way to get this information?
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- The requested resource is in use. I have caching enabled on all webs.
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 date. This just happened after the latest hotfixes were install this week.
I have also tried re-syncing the IWAM account but that didn't work either... Running the webs in HIGH (isolated) did not help either. I hit ASPFAQ.com and followed the instructions there .. is reinstalling IIS my last resort? If I restore my backed up metabase will I introduce this problem again?
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 my home machine.
I only get the error when I create a new directory in wwwroot and designate it as an application. If it's simply a subdirectory of wwwroot I can access the asp page just fine. Try to set it up as an application and I get the error. I am running IIS on XP Home and it's working fine exept for this error.
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 . Code:
I have a problem with IIS + ASP. If I try to read asp page display me this error: The requested resource is in use. In Evet Wiever i have this message: Out of process application '/LM/W3SVC/1/ROOT' terminated unexpectedly.
I install a new forum for my web site, but when i try to login or post a new message it gives this message : "The requested resource is in use." How can i solve this problem ? Why server gives thi message ?
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 project server web access screen I get the error "The requested resource is in use." I've tried researching this issue, but haven't been able to find any usable information. At this point, I'm totally stuck. Has anyone else encountered this problem?
When I'm trying to start the smtp virtual server the status of the smtp server is showing 'the requested Control is not valid for this service' Its state is shown as unknown.Wat ay be the reason. The messages I'm sending is going to the pick up directory from there its not taking
I was getting this error message using an ASP to run a stored procedure in ORACLE. ORA-01013: user requested cancel of current operationMy stored procedure was taking a long time to process.
In the ASP page:
set cmd = server.CreateObject ("ADODB.Command") with cmd set .ActiveConnection = cnn3 ..CommandTimeout=300 '' <= I added This ..CommandText = mySQL ..CommandType = 4 'adCmdStoredProc
I am -totally- new to programming. I got stuck with this assignment because no one else wanted it so it was assigned to me. I am looking for a book that covers ASP that is easy to read and more importantly easy to understand. I don't have much time to learn this language. We have several problems at our site and they expect me to fix them ASAP.
I have an ASP page with a form that then I submit to a second page, i have been trying it locally on my test server, (IIS from Windows XP SP1), and it works perfectly. The data is sent correctly, and I can manage it on my second page. For transming the data I use the post method in my form.
Then I uploaded these two pages to the production server (Windows 2003 Server), where I have a lot of files that works identacally. When I call the first page, it loads correctly, I am able to fulfill the form, but when I click the send button, the server send me the "Error 500, Internal Server Error", with no more information.
I have cheked for speling mistakes in the name of the files and in the action section from the form tag in the first page, but everything is ok, my asp code is also ok but I have no clue or idea why this fails. Code:
I have an email containing link say (somelink.asp) A user clicks on this link (say from outlook). because this user is not logged into the site, the request goes to somelink/login.asp.
The user then logs in. After successful login I would like to take this user to the link he clicked on originally. Is this possible without having to pass the lionk url as part of the query string?
The SQLServer and Web server are different computers. The error I got when logging on as ONLINE/ONLINE is "Cannot open database requested in login '<mydbname>'. Login fails. /<mysitename>/validate.asp, line 12
Line 12 is: objConnection.Open Session("ConnectionParameter")
In global.asa, the setting is:
If Session("DataBaseBrand") = "SQLSERVER" Then Session("ConnectionParameter") = "DSN=Alecto;UId=ONLINE;Pwd=ONLINE"
The names of UserID/Password fields on the form are dfsUserID/dfsPasswd
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using <%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%> <!--it is requested from "Application_Form.asp, do something--> <%else%> <!--Application_Result.asp refreshed itself(such as user clicks on the browser Refresh button, do something else--> <%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
