Microsoft Oracle ODBC driver and ADO 
Author Message
 Microsoft Oracle ODBC driver and ADO

We have a C++ application that used the native Oracle ODBC driver to
access an Oracle DB via ADO. After discovering a bug in the new 8i
version of the driver, Oracle support recommended we switch to the
Microsoft Oracle driver. We are using Oracle 8.1.7 and I have latest
MDAC running (2.6 SP1).

The application populated data in the recordset via ADO, using the
Recordset object. I have found a few places in the program where
performance on the Recordset.Update method is drastically slower on
the MS driver vs. the Oracle driver. The difference is magnified in
larger tables.

Here is the connection string that is used:
hr = Recordset->Open(vTableName, vNull, adOpenStatic,
adLockPessimistic, adCmdTable );

Then the Recordset.AddNew method is invoked, the appropriate fields
are populated, and the Recordset.Update method is called.

Similar code is run for updates of existing records.

Has anyone seen this kind of performance? Is the MS driver's
performance just that much poorer?


Tue, 20 Apr 2004 06:31:07 GMT  
 Microsoft Oracle ODBC driver and ADO

I should have clarified that, because I am not a C++
programmer, I replicated this issue in Visual Basic using
ADO as described above.


Tue, 20 Apr 2004 06:42:08 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Oracle ODBC driver / Microsoft ODBC driver for Oracle

2. Decimal Problem usind ADO and Microsoft Oracle ODBC driver

3. HELP on connection to Oracle with Microsoft ODBC for Oracle Driver

4. How to increase the buffer size of Microsoft ODBC driver for Oracle

5. Oracle 8.1.5 and Microsoft ODBC Driver

6. Microsoft ODBC driver for Oracle, version2.0

7. Microsoft ODBC Driver for Oracle : RowLimit

8. Need to reinstall Microsoft ODBC Driver for Oracle ?


10. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

11. How to see first line as data with ADO+ODBC/Microsoft Text Driver

12. ADO and Oracle ODBC drivers


Powered by phpBB® Forum Software