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" -->

		if name="" or ranking="" or notes="" then
		response.write"الرجاء ادخال جميع الحقول المطلوبة"
		addSQL="insert into guestbook (addedin,name,email,ranking,notes) values('"&addedin&"','"&name&"','"&email&"','"&ranking&"','"&notes&"') " 
   		response.redirect "guest.book.asp"
   		End if
		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 ????

Recommended Answers

All 2 Replies

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.

* 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.