Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 255707 - Last Review: September 30, 2003 - Revision: 2.0
PRB: Error 800a0cb3 on AddNew or Update Method When Using Microsoft Oracle OLE DB Provider
This article was previously published under Q255707
When you perform updates or add new records to an Oracle database by using Microsoft ActiveX Data Objects (ADO), the following error may occur:
ADODB.Recordset (0x800A0CB3)
Object or provider is not capable of performing requested operation.
This error message is generated because the Oracle OLE DB Provider does not support server-side updates.
You must use client-side cursors to perform updates against an Oracle database by using the Microsoft Oracle OLE DB Provider. To do this, before opening the recordset, specify the CursorLocation property to equal
adUseClient (or the number "3").
This behavior is by design.
Steps to Reproduce Behavior
To reproduce this behavior, perform the following steps:
- Create a sample table in Oracle with some data by using the following SQL statements:
CREATE TABLE MYACCT
(ACCT_NUM NUMBER CONSTRAINT pk_Acct_Num PRIMARY KEY ,
CUST_NUM NUMBER,
ACCT_NAME VARCHAR2(255))
INSERT INTO MYACCT VALUES(111,111,'Barry Blue')
- Insert the following code into a new Microsoft Active Server Pages (ASP) page:
<%@ Language=VBScript %>
<!--METADATA TYPE="TypeLib" NAME="Microsoft Remote Data Services Server 2.5 Library" UUID="{9381D8F6-0288-11D0-9501-00AA00B911A5}" VERSION="1.5"-->
<!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.5 Library" UUID="{00000205-0000-0010-8000-00AA006D2EA4}" VERSION="2.5"-->
<%' Replace the above two lines with the following lines to use MDAC 2.6
'<!--METADATA TYPE="TypeLib" NAME="Microsoft Remote Data Services Server 2.6 Library" UUID="{9381D8F6-0288-11D0-9501-00AA00B911A5}" VERSION="1.5"-->
'<!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.6 Library" UUID="{00000206-0000-0010-8000-00AA006D2EA4}" VERSION="2.6"-->%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
Dim cn, rs
Set cn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
cn.Open "Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=YourDataSource;"
' rs.CursorLocation = adUseClient ' Uncomment this line to cause this code to work properly.
rs.Open "SELECT * FROM MYACCT", cn, adOpenKeyset, adLockOptimistic
rs("ACCT_NUM")=333
rs("CUST_NUM")=333
rs("ACCT_NAME")="barry white"
rs.Update
%>
</BODY>
</HTML>
- Save the page in a folder that is part of a Web application in Internet Information Server (IIS).
- Browse to the page using Internet Explorer.
APPLIES TO
- Microsoft OLE DB Provider for Oracle Server 1.0
- Microsoft OLE DB Provider for Oracle Server 1.0
- Microsoft OLE DB Provider for Oracle Server 1.0
- Microsoft OLE DB Provider for Oracle Server 1.0
| kbdatabase kbprb KB255707 |
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate