Could not load file or assembly error in VS 2010 and CR

when u received this kind of error


"Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified."

Solution: 

1. First, set your framework to 4.0 full, not the client. CR requires access to the full framework.
 


2. Then add this to your app.config:

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
  </startup>

try to add this to your .config file (usually app.config)


< startup useLegacyV2RuntimeActivationPolicy="true">
< supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
< /startup>


PS: don't forget to remove extra space after "<" because blogger need the extra space so it can display correctly

Read More

Fix problem “The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly”

“The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly”

Visual Studio 2010 and SQL Server Express have an uneasy alliance, at best.  When you install Visual Studio 2010 it installs SQL Server Express 2008 for you, but only the database engine, not SQL Server Management Studio.  If you mess with SQL Server Express in order to install the management tools, or upgrade to 2008 R2, or install the Advanced Services version, things break and you can no longer reliably use the Visual Studio database projects.

In particular, if you remove SQL Server Express 2008 and install SQL Server Express 2008 R2, you’ll probably run into an issue where if you try to open a schema object in a Visual Studio database project you’ll get an error that says:

The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly.

The fix for this problem can be found here.  Here’s the short version:

1. Locate your Visual Studio 2010 installation media.
2. In the \WCU\DAC folder, you’ll find three MSIs: DACFramework_enu.msi, DACProjectSystemSetup_enu.msi, and TSqlLanguageService_enu.msi.  Run and install each of them.
3. Reapply Visual Studio 2010 SP1.

You should be back to a working state.

Read More

Fixed Problem “The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly”

“The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly”

After long time, I have got some relax from work pressures. I have got lots of mail about several issues. I had tried to give them hot fix with in a very short time. Sorry to everyone for my late response.

Today, when I am setting my new laptop I have faced a problem in VS 2010. Just run the VS2010 and got the error,

The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly.

I don't understand why this is happening?

Potential cause:
This problem may occur due to install SQL Server Express 2008 with Visual Studio 2010 installation. When install SQL Server 2008 r2 on the same machine I had got an exception. So that I have uninstalled SQL Server Express 2008 from machine and then install SQL Server 2008 r2 but installation not completed successfully.

Solution 1:
I have got the solution from this link.
To fixed my problem I did the following tasks

Step-1: Run the Visual Studio 2010 Ultimate  disc
Step-2: Explore  \WCU\DAC folder from disc
Step-3: Now installed the three packages from the Visual Studio 2010 Ultimate disc and it fixed the problem right away for me.

Microsoft SQL Server 2008 R2 Data-Tier Application Framework with this command:
\WCU\DAC\DACFramework_enu.msi

Microsoft SQL Server 2008 R2 Data-Tier Application Project:
\WCU\DAC\DACProjectSystemSetup_enu.msi

Microsoft SQL Server 2008 R2 Transact-SQL Language Service:
\WCU\DAC\TSqlLanguageService_enu.msi

If required you can re-install the Visual Studio 2010 Service pack 1.



Solution 2:
You can also try with this solution though it is not tested
1. Open Visual studio 2010 command prompt
2. Right click on it to run as an Administrator
3. execute this command:  devenv.exe /resetskippkgs

FYI: For latest Microsoft SQL Server Data Tools visits here.

Read More

Download Crystal Reports for Visual Studio 2012

By default, Visual Studio doesn’t come with Crystal Reports. Microsoft has now its own reporting tool with an .rdlc extension. In order to use Crystal Reports for Visual Studio, you need to download it from SAP’s website.

Crystal Reports is now called “SAP Crystal Reports, developer version for Microsoft Visual Studio” and can be downloaded at http://scn.sap.com/docs/DOC-35074.

You can also download it directly here:http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_5.exe

The current version as at the time of this writing is 13.0.5. You may need to visit the link above to get the latest release.

Read More