We are developing an ASP.NET application and have some problems with integration with MS dll (Microsoft.AnalysisServices)?
The original project was associated with a dll that ships with SQLServer2005 (version = 9.0.242.0). After migrating to SQLServer2008R2 (version = 10.0.0.0), we encountered this problem:
Failed to load file or assembly Microsoft.AnalysisServices, Version = 9.0.242.0, Culture = neutral, PublicKeyToken = 89845dcd8080cc91 'or one of its dependencies. The system cannot find the file indicated.
This is understood because we will compile the project with one version, and then another version is on the server. After installing SQLServer2008R2 on the development machine, the problem was fixed.
However, we now have another problem that is needed to support SQLServer2005 and SQLServer2008R2 environments. I know that we can redirect the search path for the dll using the configuration file (so that it looks for another version with which it was compiled), but I can not find instructions on how to use it for a web application (on w3wp). We tried to use "Specific Version" = false, but since this is a Strong Name assembly, it does not work, as you might think.
The corresponding link I found is:
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/47d0b992-3c10-4851-b2a5-9f72d2c0976e
Can anyone direct me to a link to solve this problem?
: , , SQLServer2008 R2. , newVersion. !, , , 9.0.242.0, 9.0.242.0, 10.0.0.0. ,
user1271762