Post reply

SQL 2005 Developer Error!!! Yikes.

  • June 22, 2006 at 1:36 am

    #171399

    Hey gang. I just got 2005. And upon connection. This prompt (see below) pops up. Any thoughts?

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

  • June 22, 2006 at 2:36 am

    #645203

    The IServiceProvider COM did not register correct.

    Merge your registry with this text (found on internet search).

    Windows Registry Editor Version 5.00

    [HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]

    @="IServiceProvider"

    [HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]

    @="4"

    [HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]

    @="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

    [HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]

    @="IServiceProvider"

    [HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]

    @="4"

    [HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]

    @="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]

    @="IServiceProvider"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]

    @="4"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]

    @="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

    If that doesn't work, try to re-register actxprxy.dll file in system32 directory.

    N 56°04'39.16"
    E 12°55'05.25"

  • June 22, 2006 at 7:57 pm

    #645424

    Thank you very much Peter. That did the trick and now it works beautifully.

    Christian

  • June 22, 2006 at 8:46 pm

    #645431

    Which one worked?  The merge or the reregister?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply