Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 1st, 2009, 07:35 AM
Registered User
 
Join Date: Jun 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Question (0x800A0CB3)recordset doesnt support updating.limitation of provider or selected lock

Code:
Stroldeml = Request.Form("sndoldml")
Strneweml = Request.Form("sndnewml")
Txtnwml = Request.Form("nwml")
pw = Request.Form("userpassword")
Set MyLogin = Server.CreateObject("ADODB.Connection")
ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};pwd=password;"
ConnStr = ConnStr & "DBQ=" & Server.MapPath("users.mdb")
MyLogin.Open(ConnStr)
SQLtemp1 = "SELECT * FROM CustRecords WHERE Cust_Username = '" & Request.Form("username") & "'"  
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs = MyLogin.Execute(SQLtemp1)
rs.Open SQLtemp1,MyLogin,adOpenDynamic,adLockOptimistic
If rs.recordcount > 0   Then
rs("Email2")=Txtnwml
rs.update
Error in rs.update.Kindly tell me where the error lies.I have tried using different lock types and different cursor types.I am using access database.





Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB.Recordset (0x800A0CB3) hbansal Classic ASP Databases 3 June 28th, 2008 01:38 AM
Big limitation in SSIS - No unmanaged code support johnperez BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 March 28th, 2008 11:58 AM
OBJECT DOESNT SUPPORT THIS PROPERTY OR METHOD KGANESH2006 Classic ASP Basics 4 March 24th, 2006 11:15 AM
Current Recordset does not support updating. u813222 Classic ASP Professional 1 March 3rd, 2006 08:41 PM
ADODB.Recordset (0x800A0CB3)Current Recordset does tks_muthu Classic ASP Databases 0 June 16th, 2005 07:22 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.