Re: Oracle 8.0.5 and ADO 2.0 Question

From: Peter Meinl <peter.meinl_at_istec.de>
Date: Tue, 27 Apr 1999 10:35:27 +0100
Message-ID: <#BsbTkIk#GA.261@cppssbbsa03>

In every past project (be it with Access, MS SQL or Oracle) it has been an nightmare to find a working ODBC driver!

For our current VB6/ADO/Oracle8.05 Project we decided to use the ADO OLEDB Provider for ODBC and the latest MS Oracle ODBC Driver (comes with MSDAC 2.1).

We expect the ODBC driver to be more stable than the native OLEDB Provider. It works better with the data environmet designer (i.e. ist able to retrieve parameter info from oracle). MS support confirmed that there are no major perfomance penalties with this approach.

Concerning your error "operation not allowed when the object is closed": Maybe you closed the recordset instead of setting its active connection to nothing (Set MyRst.ActiveConnection = Nothing or Set MyConnction = Nothing). Received on Tue Apr 27 1999 - 04:35:27 CDT