The information in this article applies to:
SYMPTOMSWhen attempting an ActiveX Data Objects (ADO)/ Remote Data Services (RDS) update, using the OLEDB provider for ODBC (MSDASQL) with a third party ODBC driver, you may receive an error. CAUSEThe error results from the third party ODBC driver not supporting positioned updates, for example SQLSetPos(). This behavior does not occur with the Microsoft ODBC driver because it does support positioned updates. RESOLUTION
A workaround for this error is to use searched updates, which are described
in the ODBC 3.0 Programmer's Reference book. To force searched updates with
ODBC you can add a WHERE clause to the SELECT statement that forces ODBC to
simulate positioned updates. Additional ODBC calls are made using the
SQLPrimaryKeys or SQLStatistics functions in order to obtain the necessary
unique identifiers for the update.
STATUSThis behavior is by design. REFERENCESODBC 3.0 Programmer's Reference; Volume 1, pg. 219. Additional query words: kbOLEDB200 kbOLEDB150 kb3rdParty kbODBC
Keywords : |
Last Reviewed: November 10, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |