Please help me out. I am looking to filter records to a specific day. Here is my error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record./calmenu.asp, line 0
<code>
<%
objRS.Filter = "eventdate = 1"
If IsNull(eventcaption) Then
eventcaption = ""
Else
Response.Write(objRS("eventcaption"))
objRS.Movenext
objRS.Filter = adFilterNone
End If
%>
</code>
Mainly I am asking if someone can look at a small portion of code to see if there are any obvious problems for use with mysql??perhaps with the way dates are inserted?? Code:
View Replies View RelatedIs 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?
View Replies View RelatedAnyone come across this error before? Its responding to <%=rs("FIRM")%>, but I have it declared in a sql statement in the code. Any ideas? Code:
<%
Set cst = Server.CreateObject ("ADODB.Connection")
Set RS = Server.CreateObject ("ADODB.Recordset")
DBpath = server.MapPath("../../../NHITADATABASE2.mdb")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBpath & ";"
cst.Open strConn
mysql = "SELECT lname, fname, email, firm, import_pro, export_pro, title, city, st, email, regions, country, website, address1, address2, zip, languages, product_service_description FROM NHITAmembership"
'Set rs = MyConn.Execute(mysql)
%>
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.
View Replies View RelatedIIS 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.
View Replies View RelatedI 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 ?
View Replies View RelatedI 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 am getting an error message - The requested resource is in use on Windows
Server 2003.
I have tried check and uncheck the Cache ISAPI extensions. The web server can serve up HTML pages and images. The problem is with the ASP/ ASPX pages.
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?
if iam requesting a form field, how do i trim that to just the first 2 letters Code:
View Replies View RelatedI'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:
I am taking my first crack at writing some ASP and have no clue as to what this error is pertaining to. I will be in your perverbial debt for ever!
----------------------------------------------------------------------------
The error I am getting is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/agentlookup.asp, line 8
-----------------------------------------------------------------------------
And here is the code it is referencing: Code:
going from Users to Organization (links)
or vise versa and totally at random.The error message appears in a pop up window:
"Internet Explorer cannot open the Internet site "file://C:aaProject
x.x.x.x 80.hta".
Operation aborted. OK"
After clicking OK the system will continue to work.
This problem is not consistent and is seeing on part of clients PC.
I found that most of these computers are using proxy server for Internet
connection.
Does anyone have some good advice for the following situation?
If a condition is true, an insert is restricted ( aborted ) otherwise
the insert is allowed. I have been killing myself on this for a week
with no success. I just need some advise at this point. Currently I
am running a stored proc that returns yes or no based on the variables
that a user is inputting. If the sp result is yes ( a record already
exists ) the insert isnt allowed and the user is forced to update the
existing record.
I'm using Shadow's upload script. whenever i try to upload a file larger than a few hundred kilobytes, i get this error: "operation not allowed; /_uploader.asp, line 56" at the top of _uploader.asp, i have changed the maximum file size to 50 mb. this is line 56 on uploader.asp:
View Replies View RelatedI don't know the exact operators, but it's something like:
a?b:c
Which translates to:
If a = TRUE then
return b
else
return c
end If
I need this for an ASP script.
I've got a page that users of my website are sent to when they log in, and one part of it shows their friends (think myspace). The page works fine if the user has one friend, but it seems that if they have more than one then i get the "Operation not allowed" error.
I won't post the whole page because there's about 750 lines of it, but here's the code that gets the friends images from a mysql db and then shrinks them (if necessary) and puts each image into a table (for a tidy layout):
NOTE: "sql" is in case there is more than one users image to get, i've checked the query when there is more than one user image to get and it looks fine... Code:
Any ideas what this could be?? Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/project/reg.asp, line 34
I have moved an ASP application to Windows 2003 and I have problems as I am currently using an Access Database until I upgrade it.
However, I am getting the error:
Operation must use an updateable query.
I have had this before so this didn't bother me too much. I added my IUSR_WINSERVER2003 to the security tab of the folder containing the database and gave read/write permissions.
However, I am still getting the updateable query errors!
I even added the Everyone account temporarily to see if it made a difference - and I still get the error.
Is there something new in Win 2003 ? Can anyone help me?
I've been trying to make my db web applications to work in
my test server and I keep getting this everytime I try to
modidy the database:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
The curious thing is that in my web hosting provider's
space it works perfectly. I don't know what's wrong with
the configuration of my IIS. Any ideas?
I look at this document (nonsense):
http://support.microsoft.com/default.aspx?scid=kb;en-
us;q175168
what the message 'Operation must use an updateable query' means. I've been to the Microsoft site as well as numerous other sites and have tried all the remedies regarding permissions etc but nothing seems to work.
The application was working perfectly previously but since backing up the site and reformatting the computer it just won't let me access the DB (Access). Perhaps I'm setting the permissions incorrectly.
I am a newbie to all this, but it was all working fine for a while then i stope working. Ive got a Flash Form, and storing that data in a database. As i said it was working all fine and nice. Then this message started to show:
Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/processForm.asp, line 15
and the ASP code i use is: Code:
I want to do bitwise operation on some large integers.
For example,
Response.Write CBool(2 AND 2^30) ' returns False
Response.Write CBool(2 AND 2^31) ' CRASHED!
Looks like the AND operator can only deal with integers up to 2147483647? Is there a way to make the AND operator work with larger integers,such as the double datatype?
using Access, i'm trying to input form info into a database.
below is the part of the code that's giving me problems:
' Creating Connection Object and opening the database
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
con.Execute sql_insert
i get this error whenever i submit the form:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
I'm trying to run an UPDATE operation, using a command object. I'm getting the error back, Operation must use an updateable query. I'm not sure if I'm doing something wrong here.
Would it be the Command object settings you have to set before executing the command? Can someone tell me what those settings should be for an update query?? Is there a lock on the table from somewhere else???