Visual Studio 2010 Report rdlc "error could not load file or assembly"

Question

I have a website created, originally in VS2005, then migrated to VS2008 and now VS2010, using .net 4.0. I did not try to use Reports in the previous versions so do not know if it worked before the upgrade.

The solution also has a business layer and a DAL. I have ensured that all projects are using the .NET 4.0. 

 

I have created Report (report.rdlc) and added a table and I want to connect the table to an objectDataSource. In the report designer I am clicking on Create New Data Source. I am then getting an error "Microsoft Report Designer" "Undocumented error". Clicking on the details button I get:

"Could not load file or assembly 'DAL_LINQ, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."

where DAL_LINQ is my data access layer.

 

If I try to run the wizard, I get the same error before the 1st step of the wizard.

If I create a new website project (without any sub projects) it works fine.

I've seen a number of posts relating to this problem but I've not found any solutions that work for me. The post closest to my problem is still unanswered.

---

Dave

Answer 1

Try putting your custom assembly in the [ProgramFiles32]\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies folder and see if that solves the issue.

Matt M 
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties

Answer 2

Hi Matt, thanks for the reply.

I my DLL to the folder you suggested but strangely it found my DAL_LINQ dll but complained about another DLL that I had also copied into this folder. I ran ProcessMonitor and it was looking for the files in the folder C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CommonExtensions\DataDesign.

I moved the DLLs into this folder and now Visual Studio hangs* when trying to open the New Data Source window.

Update: I thought it had hung, but the dialog box opened after 35 minutes!

 

Dave.

---

Dave

Answer 3

Update: I thought it had hung, but the dialog box opened after 35 minutes!

After this intial hiccup where visual studio appeared to have hung, it is now behaving perfectly. The DLLs that I copied to the DataDesign folder are now out of date but I have not had a need to update them as VS picks up the correct version for the report design. It appears it only needs these DLLs in the DataDesign folder when 1st opening.

 

---

Dave

Answer 4

Thanks, this worked for me too......... :)