Can't create a "New OLE DB connection" in the SQL Server Business Intelligence Development Studio

Posted on 2007-10-04
Last Modified: 2013-11-30
When we try to create a "New OLE DB connection" in the SQL Server Business Intelligence Development Studio we get the following error:

TITLE: Microsoft Visual Studio

Creating an instance of the COM component with CLSID {C8B522D0-5CF3-11CE-ADE5-00AA0044773D} from the IClassFactory failed due to the following error: 8007007f.



The Environment in a Windows 2003 Sever SP2
SQL Server 2005 SP2

{C8B522D0-5CF3-11CE-ADE5-00AA0044773D}  references the oledb32.dll at c:\Program Files\Common Files\System\Ole DB.  We replaced the file and re-registed it from the service pack, but the error still occurs (we also replaced the copy in dllcache).

When we run the MDAC component checkermost files that are mismatched are newer versions than the checker was looking for (comparing against MDAC 2.8 SP2).  There are a couple of files that an older version and we are going to try replacing them.

Has anyone seen this issue before?  Thanks in advance for any help you are able to give.
Question by:lrkwalkers
    1 Comment
    LVL 30

    Accepted Solution

    Just a thought:

    Create a new text file, rename it .UDL, double clik it and select the same connection type. Do you get the same error or a more meaningful error?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now