Description
When attempting to add an "OLE DB Command" object in Microsoft Visual Studio 2005 on a Windows 2003 x64 server, you get the following error message:"Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft Visual Studio)
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Runtime.InteropServices.CustomMarshalers.EnumerableViewOfDispatch.GetEnumerator()
at System.Collections.IEnumerable.GetEnumerator()
at Microsoft.DataTransformationServices.Design.Controls.ComponentMetaDataTreeView.AddColumnNodes(DtsObjectTreeNode parentNode, Hashtable& allNodes, IEnumerable columnCollection)
at Microsoft.DataTransformationServices.Design.Controls.ComponentMetaDataTreeView.AddExternalMetaDataColumnsNodes(DtsObjectTreeNode parentNode, Hashtable& allNodes, Int32 inputOutputID, IDTSExternalMetadataColumnCollection90 externalMetadataColumnCollection)
at Microsoft.DataTransformationServices.Design.Controls.ComponentMetaDataTreeView.AddInputNodes(Hashtable& allNodes, Int32& rootNodeIndex)
at Microsoft.DataTransformationServices.Design.Controls.ComponentMetaDataTreeView.FillTreeView()
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowColumnPropertiesPage.ShowPage()
at Microsoft.DataTransformationServices.Design.FunctionLevelMappingUI.InitializeColumnPropertiesPage()
at Microsoft.DataTransformationServices.Design.FunctionLevelMappingUI..ctor(FunctionLevelComponentUI componentUI, IUserPromptService promptService)
at Microsoft.DataTransformationServices.Design.FunctionLevelComponentUI.EditImpl(IWin32Window parentControl)
at Microsoft.DataTransformationServices.Design.DtsComponentUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections)"
Solution
1) Open Command Prompt2) cd "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn" && for %i in (*.dll) do %windir%\syswow64\regsvr32 /s %i
Affected software:
Microsoft Windows 2003Visual Studio 2008