Member Avatar for SBox

i wrote an asp script and when i made the guest book ( when i used the addSQL ) this error returned

Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/science/add.sign.asp, line 15

This is the add.sign.asp

<!--#include file="connection.asp" -->

	<%
		
     	addedin=now()
		name=request.form("name")
		email=request.form("email")
		ranking=request.form("ranking")
		notes=request.form("notes")
		
		if name="" or ranking="" or notes="" then
		response.write"الرجاء ادخال جميع الحقول المطلوبة"
		else
		addSQL="insert into guestbook (addedin,name,email,ranking,notes) values('"&addedin&"','"&name&"','"&email&"','"&ranking&"','"&notes&"') " 
   		SB.execute(addSQL)
   		response.redirect "guest.book.asp"
   		End if
		
		SB.close
		Set SB=Nothing

	%>

But when i uploaded the script to my hosting it worked 100% so is the error from the iis ???
what can i do about that ????

  • 2 Contributors
  • 2 Replies
  • 139 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by SBox
Member Avatar for techniner

Let me get this straight, it does not work locally but is working on your host?

Chances are it is a permissions issue, on your local machine.

Member Avatar for SBox

* Yah, it does not work locally but is working on your host.

* So hwo can i fix this problem ( permission ) ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.