Some of the code I have in my asp is below. The line that causes the error is this: myrecordset("categoryname") = Request("categoryname")

Could you send some sample code if you have one handy? Thank you.

<%
Dim myConnection
Dim myRecordset
Dim myVariable

Set myconnection = CreateObject("ADODB.connection")
myconnection.Open application("connection1_connectionstring"), _
Application("connection1_runtimeusername"), _
Application("connection1_runtimepassword")

Set myrecordset = CreateObject("ADODB.recordset")
myvariable = "SELECT * FROM categories WHERE categoryid =" & Request("categoryid")
myRecordset.Open myvariable, myconnection, adOpenStatic, adLockOptimistic

myrecordset("categoryid") = Request("categoryid")
myrecordset("categoryname") = Request("categoryname")
myrecordset.update

response.write "Thank you.
"
response.write "The updated record has been posted!"

myrecordset.Close
set myRecordset = nothing
myConnection.Close
set myconnection = nothing
%>

>Can you post the offending code? Be sure to indicate which line is throwing the error.
>
>>I am getting this error message when I try to update a VFP table through my ASP. Any ideas how to fix it?
>>Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
>>The request properties can not be supported by this ODBC Driver.
>>
>>
>>This is the solution I get from the KB but I don't know where to go because I am not using any DTCs.
>>
>>RESOLUTION
>>When the Recordset DTC has the cursor location property set to "2 - Use Server Side Cursors" (the default value), it cannot return multiple recordsets. Under the Properties dialog box for the Recordset DTC, go to the Advanced tab and change the cursor location from "2 - Use Server-Side Cursor" to "3 - Use Client-Side Cursor."