When trying to connect to a new database engine, I would would receive the following error:
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)
I found two resources to fix this; the first is a registry hack, the second refers to dll to register. I chose the second and my issue went away.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=120476&SiteID=1
http://support.microsoft.com/kb/953492/en-us
As you can see the second link is from Microsoft support, which I gravitated toward fist.
I used the components guid, 6D5140C1-7436-11CE-8034-00AA006009FA, for my search.
Good luck, I hope this helps someone out there
5 comments
Comments feed for this article
Friday, December 12, 2008 at 16:04:12
Hank Lynch
Helped me!
Thank you.
Friday, December 19, 2008 at 10:10:49
Brettski
Your welcome, glad I could assist someone.
Tuesday, March 27, 2012 at 20:08:14
Mani
I get the same error. Re registering actxprxy.dll does not work. I use win 7 64 bit
Tuesday, March 27, 2012 at 23:11:13
Brettski
If you do find a solution, please post it here to help others. I will add it to the entry above too. Thanks for commenting.
Saturday, December 1, 2012 at 9:09:59
explorer
does not work. I use win 7 64 bit