Hello friends,
I have a question this ASP runs on ADO 2.1 & 2.5 but it dues not run on ADO 2.0
When i run it on 2.0 i get the following error:
And here is my ASP trouble code :Code:Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query. /howyoucanhelp/submit.asp, line 15
Shall i use Recordset to make it work or what?Code:set objDBConn=Server.CreateObject ("ADODB.Connection") objdbconn.Open "Petition" strSQL = "Insert Into Petition (Name, Address, _ City, State, Zip, Email) Values ('" & Request.Form("Name") & "', '" & _ Request.Form("Address") & "', '" & _ Request.Form("City") & "', '" & _ Request.Form("State") & "', '" & _ Request.Form("Zip") & "', '" & _ Request.Form("Email") & "')" objDBConn.Execute (strSQL) objDBConn.close set objDBConn = nothing
Please help. I need to get it running on MDAC 2.0!
Thanks




Reply With Quote