Clever Geek Handbook

Connecting to AdventureWorks Database (SQL Server 2005 Express) through Visual Studio Professional 2008

I am following the ASP.NET 3.5 O'REILLY tutorial to write some ASP.NET 3.5 code using Visual Studio 2008 SP1. I got to the point where I need to set up a data source using a SqlDataSource control. I chose Microsoft SQL Server (SqlClient) , although I have SQL Server Express 2005. This seems like the only logical choice.

I go to Add Connection window and add Server Name successfully and I use Select or enter AdventureWorks database name . When I click on Test Connection, I get a Test Connection Succeeded message .

Unfortunately, when I click OK, the following error message appears:

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral,
PublicKey Token=89845dcd8080cc91' or one of its dependecies.  The system cannot find
the file specified.

In turn, I am at a loss, and everywhere I look and find something similar to my problem, it is related to other versions of Visual Studio or SQL Server.

I would really appreciate any help on this!

+1


source to share


3 answers


You can research this recipe.



+1


source


You may need to reinstall your copy of SQL 2005 Express. But be sure to install all client developer packages in the installer.



0


source


I had the same problem.

Following the suggestions in this thread , I went to " Microsoft SQL Server 2008 Feature Pack, August 2008 " - and downloaded (and installed) "Microsoft SQL Server 2005 Backward Compatibility Components". It did not help.

Then I also downloaded and installed the following components: SharedManagementObjects.msi, sqlncli.msi, SQLSysClrTypes.msi.

And now it works for me.

I am using SQL Server 2008 Express and Visual Web Developer 2008 Express Edition.

0


source






More articles:


All Articles