Article ID: 292604 - View products that this article applies to.
This article was previously published under Q292604
This article has been archived. It is offered "as is" and will no longer be updated.
When you use a client-side cursor against an Oracle database with the Microsoft ODBC Driver for Oracle, a deferred update is not successful and you receive the following error message:
This occurs when the SQL SELECT statement includes a WHERE clause that has an embedded bracket. The problem only occurs with a client-side cursor when the criteria in the WHERE clause of the recordset is put in parentheses and the string criteria contains brackets.
0x80004005 ("Insufficient base table information for updating or refreshing")
The ActiveX Data Objects (ADO) Client Cursor Engine does not successfully parse the statement, and cannot update the recordset.
To resolve this problem, obtain the latest service pack for Microsoft MDAC 2.5. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
293312The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
(https://support.microsoft.com/kb/293312/EN-US/ )INFO: How to Obtain the Latest MDAC 2.5 Service Pack
Date Version Size File name Platform ---------------------------------------------------------------- 03-07-2001 2.53.7307 327,952 Msadce.dll x86
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft MDAC 2.5 Service Pack 3.
The problem does not occur with the Microsoft OLE DB provider for Oracle (MSDAORA).
Steps to Reproduce the Behavior
Article ID: 292604 - Last Review: February 27, 2014 - Revision: 3.2