I don't understand this error msg

Results 1 to 2 of 2

Thread: I don't understand this error msg

  1. #1
    Join Date
    Dec 1969

    Default I don't understand this error msg

    On my computer at work this code works fine but I get an error message when I run it on my home computer. I&#039;m on IIS 5 at home and I&#039;m wandering if that&#039;s the problem.<BR><BR>The error is this :<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.<BR>/Intranet/Liste_Tel/DeleteEvent.asp, line 31<BR><BR>here&#039;s my code:<BR><BR>&#060;%<BR>&#039;Declare variables and Request values<BR>Dim Day<BR>Dim Month<BR>Dim Year<BR>Dim idSchedule<BR><BR>Day = request.querystring("nDay")<BR>Month = request.querystring("nMonth")<BR>Year = request.querystring("nYear")<BR>idSchedule = request.querystring("IdSchedule")<BR><BR>&#039;Con nect to database<BR>dim Cn<BR>dim Rs<BR>dim SQL<BR><BR>Set Cn = server.createobject("ADODB.connection")<BR>Cn.open = "Organizer"<BR>SQL = "DELETE * from Schedule where IdSchedule=" & IdSchedule<BR>Set RS = Cn.execute(SQL)&#039;THIS IS LINE 31<BR>Cn.close<BR>Set Rs = Nothing<BR>Set Cn = Nothing<BR>Response.redirect "Agenda.asp?nDay=" & Day & "&nMonth=" & Month & "&nYear=" & Year & ""<BR>%&#062;<BR><BR><BR>thanks for any help<BR>Claire

  2. #2
    Join Date
    Dec 1969

    Default RE: I don't understand this error msg

    See this FAQ:<BR><BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts