The code I have in my asp is below. The line that causes the problem is:
myrecordset("categoryname") = Request("categoryname")
because is the one that contains the updated data. Could you send some sample code if you have one asp 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."
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement