Welcome to WebmasterWorld Guest from

Forum Moderators: ocean10000

Message Too Old, No Replies

error type:Microsoft JET Database Engine.......and error 80020009

8:15 am on Jul 2, 2008 (gmt 0)

New User

10+ Year Member

joined:July 2, 2008
posts: 1
votes: 0

I would like to ask for help. I'm a beginner in this field....and really don't know how to solve the problem, besides that i didn't write the codes. they were written by my ex-colleague.
I'll try to explain what the problem is:
He made an upload form-called Newsentrya.asp.I installed and configured a virtual server IIS ver.5.1 my OS is XP Prof Ver 2002 ServPack3 and the form works without any problems but at the office i did the same cause i need a testing server for the ASPs but i have problem it gives me an error:

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/bg/Newsentrya.asp, line 69 For Each File In Uploader.Files.Items
File.SaveToDisk f
if fpath="--" then
fpath=fpath & "," & "\NewsAttachments\" & Number & File.FileName
fPath= "\NewsAttachments\" & Number & "\" & File.FileName
end if
end if
sql="insert into news_details(numNumber,dtNewsDate,txtHeadline,txtNews,dtStartDate,dtEndDate,picture)
(this is line 69!) con.Execute sql
Response.Write "<font color=red face=safon size=4><b>Data is Succesfully added</font>"

Response.Write "<font color=red face=safon size=4><b>Data is Succesfully added</font>"


POST Data:
error '80020009'
Exception occurred.

/iisHelp/common/500-100.asp, line 223
If strMethod = "POST" Then
Response.Write Request.TotalBytes & " bytes to "
End If

Response.Write Request.ServerVariables("SCRIPT_NAME")

lngPos = InStr(Request.QueryString, "")

If lngPos > 1 Then
Response.Write "?" & Server.HTMLEncode(Left(Request.QueryString, (lngPos - 1)))
End If

Response.Write "</li>"

If strMethod = "POST" Then
Response.Write "<p><li>POST Data:<br>"
If Request.TotalBytes > lngMaxFormBytes Then
(this is line 223!)Response.Write.Server.HTMLEncode(Left(Request.Form, lngMaxFormBytes)) & " . . ."
Response.Write Server.HTMLEncode(Request.Form)
End If
Response.Write "</li>"
End If

But the main problem is that on the live server - Win Server 2003 and IIS ver 6.0 and form sometimes works sometimes don't. Pls, help me to solve this problem.

[edited by: phranque at 6:47 am (utc) on July 20, 2008]
[edit reason] fix line width [/edit]

6:51 am on July 20, 2008 (gmt 0)


WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Aug 10, 2004
votes: 211

welcome to WebmasterWorld [webmasterworld.com], desconi!

have you had any luck solving this problem?

2:21 pm on July 21, 2008 (gmt 0)

Senior Member from CA 

WebmasterWorld Senior Member httpwebwitch is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Aug 29, 2003
votes: 0

That error is almost always a permissions problem. Make sure the user doing the query (it may be a user called ASPNET) has write permissions in the database.