FIX: Java OLE DB Simple Provider Does Not Work Reliably

An OLE DB Provider created using the Visual J++ 6.0 and the OLE DB Simple Provider Toolkit does not work reliably. When attempting to use such a provider from ActiveX Data Object (ADO) via the Recordset.Open() method, the following error occurs: The following application error may occur when using the provider from a Visual J++ or Visual Basic client: The following application error may occur when using the provider from a Visual C++ client:

The Microsoft OLE DB Simple Provider component (Msdaosp.dll) does not properly implement COM reference counting. This causes erratic results with any client of the provider, because the provider may release itself when its real reference count is greater than zero.

This problem has been fixed with Microsoft Data Access Components (MDAC) 2.1 Service Pack 2 (SP2). You can download the latest MDAC from the following Microsoft Universal Data Access Web site:

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

The new release of MDAC also fixes a problem in the Java OLE DB Simple Provider, which causes access violation errors when using the Recordset.Delete() method.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base: