Click here to Skip to main content
15,922,696 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I had fully working Microsoft SQL Server 2008 R2 installed and running with no errors.

2 days back I tried to install Microsoft SQL Server 2012 on the same machine. But the installation is unsuccessful due to some compatibility reasons....

Now the problem is I couldn't able to create Data source view in the Analysis Service Project... I am getting the following error....

"An error prevented the view from loading.

Additional information:
The specified module could not be found. (Exception from HRESULT:0x8007007E) (System.Windows.Forms)
"


Can anyone help me out with this......
Posted
Comments
ZurdoDev 8-Aug-12 10:12am    
Sounds like you need to reinstall 2008.
Pradeep Kumar Chowdavarapu 8-Aug-12 10:16am    
Thanks for your reply.. But I already did it twice,,, Its no use......
fjdiewornncalwe 9-Aug-12 11:11am    
System.Windows.Forms is not directly related to SQL Server, it is a base dotNet assembly. You may need to the reinstall the appropriate dotnet version that you are trying to use.

Hi,

This is for developers suffering from the following error:-
Quote:
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms)


It took me more than a day to figure out as why I get the above error when I try to open control flow design by double clicking on a *.dtsx package in Microsoft Visual Studio 2008.

The famous resolution as many of you know is to replace all the 5 DLL's [msdds.dll, msddsf.dll, msddslm.dll, msddslmp.dll, msddsp.dll] in the following location 'C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8' with fresh copy of dll's from a working machine.

Issue persisted even after replacing fresh copy of DLL's from other working machine.
Then I realised the DLL's that are replaced, each was designed for Visual Studio 2012 (in DLL properties) and my machine did not have VS-2012(as I uninstalled it few days back), latest Visual Studio version was 2008. That's it, I managed to find one such colleage who had Visual-Studio not latest than VS-2008, took the DLL's from his 'MSDesigners8' folder, copied to my machine, launched the SSIS package from VS-2008 and it works.

Note : Make sure the DLL's version match the latest VisualStudio version in your machine. In this case, SSIS opened in Ms-VS-2008 tried to use DLL's with Ms-VS-2012 version and which were not replaced with 2008 designer DLL's when VS-2012 was uninstalled.

Problem that Microsoft must resolve: If latest version of VisualStudio is installed on a machine having multiple Visual Studio versions (2k3,2k5,2k8, 2010, 2012 etc..), the common/shared DLL's that ship with it replace existing version DLL's. But when latest version is uninstalled, those DLL's are left behind, and when previous version of VStudio needs a common DLL then it error's out as it's trying to refer to a DLL which is of advanced version and that version VS is not in the system.

Cheers...
 
Share this answer
 
Comments
Yesudass Moses 14-Jan-18 3:51am    
Thank you... setting permission for these file fixed my error.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900