Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> select for update not working on W2K/ADO
We have a Windows server application that connects to Oracle via ADO using the MSDAORA provider. It works on NT (MDAC 2.1) with Oracle 7.3, but has trouble doing a "SELECT FOR UPDATE" when running the same code on Windows 2000 (MDAC 2.5) with Oracle 8.1.7. The "open recordset" works, but it throws an exception when attempting to assign the value read from the database. If the "FOR UPDATE" is removed from the select clause it works fine.
Has anyone experienced similar problems?
Should I be using ORAOLEDB instead of MSDAORA as the provider?
There is a later version of MDAC (2.6?, 2.7?). Could this be the problem?
How does the ODBC fit into the equasion: Does the MSDAORA provider connect to Oracle via ODBC while the Oracle ORA OldDB provider bypasses ODBC and talks directly to the OCI layer?
Please copy me on any resoponse (in digest mode). Many thanks for any help.
John Armani
john.armani_at_us.abb.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: john.armani_at_us.abb.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 08 2001 - 11:28:21 CDT