0

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
3
Views
9 Years
Discussion Span
Last Post by SBox
0

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.

0

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

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.