Whats going on here????

Results 1 to 2 of 2

Thread: Whats going on here????

  1. #1

    Default Whats going on here????

    Hi guys,<BR>Ive never seen this one before. This has just come about within the last 5 minutes of an application that Ive been working on for months. I KNOW for certain the database is in the correct location.<BR><BR>Why am I receiving ths crazy error message??<BR><BR>Error Type:<BR>Microsoft JET Database Engine (0x80004005)<BR>Could not find file &#039;C:WINDOWSsystem32members.mdb&#039;.<BR>/calendar/includes/declarations.asp, line 38<BR><BR><BR>Heres the code...<BR><BR>DIM action, objRS<BR>&#039;ENSURE THE BOOKINGS DO NOT EXCEED THE MAXIMUM LIMIT<BR>sql = "SELECT ID, registered, reserv_max FROM events WHERE ID = " & session("reg_eventID")<BR>RS_Open<BR> <BR>DIM regcount<BR>regcount = Cint(RS("registered")) + Cint(request.form("register"))<BR>if isNull(RS("reserv_max")) then<BR>response.write "no limit"<BR>else <BR>if regcount &#062; Cint(RS("reserv_max")) then<BR>response.Redirect("../messages/message.asp?action=fullybooked")<BR>end if<BR>RS_close<BR>end if<BR> <BR>&#039;Obtain the event particulars to send off email notification<BR>sql2 = "SELECT ev.ID, ev.addedby, mem.ID, mem.member_email FROM events ev INNER JOIN members.mem ON mem.ID = ev.addedby WHERE ID = " & session("reg_eventID")<BR>response.write sql2 & "<BR>"<BR>&#039;response.end<BR> <BR>RS_Open2<BR>response.write RS2("member_email") & "<BR>"<BR>RS_Close2<BR><BR>&#039;INSERT TO THE REGISTRATIONS TABLE<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en "registrations", Calconn, adLockOptimistic, adCmdTable<BR> <BR>objRS.AddNew<BR>objRS("eventID") = session("reg_eventID")<BR>objRS("userID") = session("ID")<BR>objRS("groupID") = session("groupID")<BR>objRS.Update<BR> <BR>sql = "UPDATE events SET " &_ <BR>"registered = " & Cint(regcount) &_ <BR>" WHERE ID = " & Cint(session("reg_eventID"))<BR>Calconn.Execute sql <BR> <BR>objRS.Close<BR>Set objRS = Nothing<BR>close_conn<BR>end if<BR> <BR>response.Redirect("../messages/message.asp?action=registered")<BR><BR>Why the hell is it pointing to &#039;C:WINDOWSsystem32members.mdb&#039;<BR><BR>Th e database is in wwwroot/calendar/database/calendar.mdb. And why is it looking for MEMBERS when the database is called CALENDAR.MDB????<BR><BR>Weird,<BR>John

  2. #2

    Default found it!

    My sql statement was wrong. Odd error though I thought.<BR><BR>sql = "SELECT ev.ID, ev.addedby, mem.ID, mem.member_email, mem.member_firstname FROM events ev INNER JOIN members mem ON mem.ID = ev.addedby WHERE ev.ID = " & session("reg_eventID")

Posting Permissions

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