Solved

error exist when execute asp code

Posted on 2003-11-16
12
432 Views
Last Modified: 2010-04-17
when i'm trying to  execute the below code, there is an error exist:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/test/real.asp, line 26


HTML FILE:formtest.html

<html>
<head><title>Maklumat Produk</title>
</head>
<body>
<body bgcolor="3399cc">
<p align="center"><b><font size="5" font color="#FFFFFF">Pelajar</font></b></p>
<img src="line1.GIF" align="center" width="600" height="10" > 
<br>  

<a href= "test.asp">[ Home ]</a>
<form action="/test/real.asp" Method=Post>
<center>

<table>
<tr><td>
<b>Matrik:</td><td><Input type="text" name="fmatrik" maxlenght="5"></b></td></tr>

<tr><td>
<b>Nama:</td><td><Input type="text" name="fnama"></b></td><tr>


<tr><td><b>Email:</td><td><Input type="text" name="fmel"></b></td><tr>

<br>
<input type="submit" value="Sila Proses" name="B1">
<input type="reset" value="Sila Bersih" name="B2">

</form>
</body>
</html>



ASP FILE: real.asp

<html>
<head>
<title>Produk</title></head>
<body><body background="_themes/blends/blegtext.gif" bgcolor="#CCCCCC" text="#000000" link="#993300" vlink="#0000FF" alink="#FF9900"><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td><!--mstheme--><font face="Trebuchet MS, Arial, Helvetica">

<center><h1><font color=blue>Proses Rekod Baru</font></h1><p>
<hr>

<%

matrik            =Request.Form("fmatrik")
nama            =Request.Form("fnama")
mel            =Request.Form("fmel")


set db=Server.CreateObject("ADODB.Connection")
db.Open"eez"

VQ="INSERT INTO zee ( "
VQ=VQ+ "matrik, "
VQ=VQ+ "nama,"
VQ=VQ+ "mel) Values (' "
VQ=VQ+            matrik+" ',' "
VQ=VQ+            nama+"','"
VQ=VQ+            mel+"')"
db.Execute VQ
db.Close
%>

<p><blink><h3>Data sudah direkodkan!!</h3></blink>
<p><hr><br><br>
<u><h3>Butir-butir yang anda masukkan adalah seperti berikut:</h3></u><p>
<dir><pre>
<table><tr><td>
<tr><td>Matrik                  </td><td>=<%=matrik %></td></tr>
<tr><td>Nama                  </td><td>=<%=nama %></td></tr>
<tr><td>Mel                  </td><td>=<%=mel %></td></tr>

</table>
</pre>
</dir>
</body>
</html>



why this happened??what should I do?plz help me....thank you...



0
Comment
Question by:eez81
  • 5
  • 5
  • 2
12 Comments
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 9761844
Hello,

Go through the link below. You will get solution...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q175/1/68.ASP&NoWebContent=1

All the best,
V.Thandava Krishna.
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 9761866
And this one also.....

http://www.learnasp.com/learn/FAQdbUpdate.asp

All the best,
V.Thandava Krishna.
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 9761872
Hello,

====================================
FAQ #1:Operation must  use an updateable query.
I get this error message when adding or modifying data

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Database Error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

is a very common error message when updating Access databases. Since Access is file based any attempt to update the database by an ASP script can only modify the Access databases if permissions are established correctly.

Go to the parent directory where the database is stored. Click on the folder permissions and set IUSER_xxxxx to 'change' where xxxxx is the machine name. Make sure the file is also set so the ISUSER_xxxx can change the file.

http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
shows some other causes besides permissions.
=====================================


All the best,
V.Thandava Krishna.
0
 
LVL 14

Accepted Solution

by:
Thandava Vallepalli earned 35 total points
ID: 9761932
Hello eez81,

If you satisfy with my answer pl. don't forget to accept the answer.  Your previous question still open.   i.e   "ASP on UNIX server"

====================================
1 11/16/2003 35 error exist when execute asp code  Open Programming
2 11/09/2003 125 ASP on UNIX server  Open Web Development
=====================================

All the best,
V.Thandava Krishna.
0
 
LVL 9

Expert Comment

by:bhagyesht
ID: 9761996
are u trying to upadate a view/query?
is the mdb file accessable for the Internet Guest account (IUSR_MACHINE) ?
does the table have indexing and a primary key defined?
is the dsn read- only?
0
 

Author Comment

by:eez81
ID: 9769387
i don't know where is Internet Guest account(IUSR_MACHINE) and dsn .plz give me the specified step.tq..
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 9

Expert Comment

by:bhagyesht
ID: 9769428
right click on the mdb file select properties
navigate to the security tab
click add
select the IUSR_Machine
click ok
now select the IUSR and give full control to the user
0
 

Author Comment

by:eez81
ID: 9769526
what do you mean by mdb file.it is my access file i'm create or it is a program??
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 9769556
MDB is your access file.  Right click on it. Select Properties.  Select Security Tab.
Click the Add button.  Select IUSR_<Your Machine Name> user.  Give full control to the selected user.

All the best,
V.Thandava Krishna.
0
 
LVL 9

Expert Comment

by:bhagyesht
ID: 9769557
the extention of your access file is mdb so i mean the access file ie the database file
0
 
LVL 9

Expert Comment

by:bhagyesht
ID: 9769561
oops too late ;-)
0
 
LVL 9

Expert Comment

by:bhagyesht
ID: 9769566
eez81 : you surely could select a proper answer. you should have selected the earlier comment which is the answer.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
scoreUp challenge 14 56
object oriented javascript web form 8 100
wordlen challenge 3 60
PHP question(s) about order of output 9 57
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now