Unable to use Query in my ASP application

Dniz · #1 (**permalink**) 12-18-04, 02:21

Hi,

I have just picked up ASP a month ago and i am learning ASP fast with additional knowledge in C programming, few knowledge in query language and html. However, I receive the same error message whenever I use query language to modify my database

, as in using INSERT, UPDATE and DELETE. I attach the add data html and code along with this thread. The database only consist of a table call CDs that has 3 fields of data, which are artist, title and format. Hope someone can give me a hand here. Thanks!

Error Message:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Addcds.htm

<HTML>
<FORM METHOD="GET" ACTION="addcds.asp">
<H3>Add CD to Database</H3>
<B>Artist</B><BR>
<INPUT TYPE="TEXT" NAME="artist" MAXLENGTH="50"><P>
<B>Title</B><BR>
<INPUT TYPE="TEXT" NAME="title" MAXLENGTH="50"><P>
<B>Format</B><BR>
<INPUT TYPE="RADIO" NAME="format" VALUE="CDA" CHECKED> Album<BR>
<INPUT TYPE="RADIO" NAME="format" VALUE="CDS"> Single<P>
<INPUT TYPE="SUBMIT" VALUE="Add to database"><P>
<INPUT TYPE="RESET" VALUE="Clear">
</FORM>
</BODY>
</HMTL>

Addcds.asp

<%
artist=Request("artist")
title=Request("title")
format=Request("format")
Query = "INSERT INTO CDs (artist,title,format) VALUES ("
Query = Query & "'" & artist & "','" & title & "','" & format & "')"
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "records"
Set RSlist = Server.CreateObject("ADODB.recordset")
RSlist.Open Query,DataConn,3
%>
<HTML>
<BODY>
<H3>CD Added To Collection Database</H3>
<HR>
<SMALL><%=Query%></SMALL>
</BODY>
</HTML>

rokslide · #2 (**permalink**) 12-19-04, 20:12

The quick and simple answer is that the user that is running IIS does not have write access to the database....

Dniz · #3 (**permalink**) 12-20-04, 22:12

How can I access to my database? Is there any extra configuration in the ODBC? I had been successfully read from the database anyway, using the select function. I assumed it's a backward process to modify the database. Have I got the idea wrong?

Bullschmidt · #4 (**permalink**) 12-29-04, 18:58

Perhaps this might help:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

Dniz · #5 (**permalink**) 01-09-05, 22:10

Would you recommend me to format my PC? I tried install and unsinstalled IIS in my computer a few times already. Also have all the permission configured. I did the same for other computer but I can used the IIS smoothly without any problem.

gyuan · #6 (**permalink**) 01-14-05, 10:43

For the INSERT statement, you need to use Execute(sql) method.

<%
Query = "INSERT INTO CDs (artist,title,format) VALUES ("
Query = Query & "'" & artist & "','" & title & "','" & format & "')"
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "records"
DataConn.Execute(Query)
%>

Dniz · #7 (**permalink**) 01-17-05, 02:10

Quote:

Originally Posted by gyuan

For the INSERT statement, you need to use Execute(sql) method.

<%
Query = "INSERT INTO CDs (artist,title,format) VALUES ("
Query = Query & "'" & artist & "','" & title & "','" & format & "')"
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "records"
DataConn.Execute(Query)
%>

I've tried the method. Thanks for your suggestion. Actually, I think the problem is with my computer, not the IIS.

Internet Services

Web Development

Digital Marketing

Consumer Tech