| Author |
Thread |
| have problem inserting content into database |
|
Posted in tutorial: Inserting Form content into Database with ASP |
· gpm1982
Joined: 23 Dec 2002 Total Posts: 2 |
have problem inserting content into database Posted: 24 Aug 2004
I have a problem here with inserting form data into database. Every time I inserted the data, this error message below appears. Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /bussing/tempdb/insert.asp, line 32 Please help me with this error. I don't know what to do right now.
Sent by:
GPM
|
· david2
Joined: 2 Jan 2005 Total Posts: 2 |
newbie qu: same qu as thread 1264. ".... updateable query" Posted: 2 Jan 2005
Hi, I have encountered the same error message described in the above message which was posted back in August, with thread # 1264. But I cannot seem to locate any previous replies to the message. Can someone please explain how I may locate previous replies if any. Does this website allow searches to be made based on keywords?
In any case, I am trying to use the code presented in "Inserting Form content into Database with ASP". When I run my own modified version of code, I got this error: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. Why?
I then copy the code exactly as presented in the article and run it. I see blank output page, and found that the error occurs in "form_ac.asp", at this line of code: con.Execute sql_insert. I see blank page. When that line is commented out, the program would proceed to completion (without doing useful work of course.) Please help. Thanx.
Regards, david
|
· david2
Joined: 2 Jan 2005 Total Posts: 2 |
CANCEL POSTING. Posted: 3 Jan 2005
Please disregard the post.
Regards, david
|
· gpm1982
Joined: 23 Dec 2002 Total Posts: 2 |
Solution Posted: 11 Apr 2005
Just forget what i asked. I finally got to know the problem and how to fix this problem. The thing is that this problem only occurs for some in localhost only, but when uploaded to the web server, the page runs smoothly.
If you want to enable insert, update, n delete function to work in localhost, please see the following link.
http://www.xlinesoft.com/asprunner/docs/troubleshooting__operation_must_use_an_updateable_query__errors.htm
Sent by:
GPM
|