The OLE DB Provider is not installed by default when SQL Server is installed. Microsoft offers the tool as part of the Microsoft SQL Server Feature Pack, or you can download just the Provider ...

The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It's a bit trickier to go in the other ...

Click "Oracle Provider for OLE DB." Click "Next" to open the box's Connection tab. Type "orcl" in the Data Source box. Click "OK" to return to the Select Database dialog box.

In the test environment (2 IIS web servers, 1 SQL server, 1 IIS Utility server) none of our DB-driven apps are working. We cannot figure out the issue, but we think that MDAC is hosed.