FIXED! ***THANK NUKE FARMER!!***

[Adul]

I get this error

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

I am trying to input data into a database from a webased form. What am I doing wrong?

here is my asp code

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<%Response.Buffer=true%>
<%
Dim conn,rs,strsql,surveyno,deptno,position
set conn = server.CreateObject(&quot;ADODB.Connection&quot
conn.Open &quot;DSN=survey;uid=user;pwd=2000&quot;

Set cmd = Server.CreateObject(&quot;ADODB.Command&quot
Set cmd.ActiveConnection = conn

deptno = Request.Form(&quot;Dept&quot
position = Request.Form(&quot;radiobutton&quot

strSQL = &quot;INSERT INTO completed_surv (dept,emp_ID) &quot;
strSQL = strSQL &amp; &quot;VALUES (&quot; &amp; deptno
strSQL = strSQL &amp; &quot;,'&quot; &amp; position &amp; &quot;')&quot;

Set rs = conn.Execute(strSQL)
Set rs = nothing

'close the connection
conn.close
set conn = nothing

%>

 

[Engine]

Shoot... it's been a while since I did ASP, but I do see one thing right off the bat. You're trying to put the results of an insert statement into a recordset. Recordsets only work with SELECTS (or stored procs that return resultsets), I think.

There might also be a parameter you have to set on the Command object to tell it not to be read only. I'll try to look it up somewhere real quick.

EDIT: You may have to set the CommandType property of the Command object to adCmdText, but I'm not sure.

 

[Adul]

DOH! I knew I did something wrong. thanks a mill

 

[Adul]

ANYONE? I am in dire straits here.

 

[Adul]

^

 

[nukefarmer]

i know next to nothing about ASP but i'll try anyway
i think the insert query doesn't return a resultset, so you might have to use conn.Execute(strSQL) instead of Set rs = conn.Execute(strSQL)

 

[Adul]

i'll try anything

 

[Adul]

nope, didnt work... arrggh

 

[nukefarmer]

maybe this'll help you out:
http://support.microsoft.com/support/kb/articles/q175/1/68.asp

 

[Adul]

Nukefarmer, your the best. Thanks a million that worked!

 

[nukefarmer]

great