Music Store Tutorial, 4th Step / Error: Unable to find the requested .Net Framework Data Provider...

Oct 22, 2012 at 4:07 PM

Having a hell of a time, for quite some time (literally months, a couple hours each day) getting through Music Store tutorial.  Without getting into detail of my trials and travails with the tutorial up until now, below outlines my current problem.  Thanks for any input anyone might offer.

MvcMusicStore.Models.StoreController
Line 18: var genres = storeDB.Genres.ToList(); 
Error: Unable to find the requested .Net Framework Data Provider.  It may not be installed.

Environment: Brand new install of:
OS (XP)
and...
ASP.NET MVC3 with Tools (first)
ASP.NET MVC4 for Visual Studio 2010 (in this order)

(although when you choose to create new project in VWD 2010, there are only the choices of creating it either in MVC2 and MVC4 (MVC3 not an available option)

I think I have .NET Framework 4 installed (see below)

Control Panels / Add or Remove Programs / Currently Installed Programs
Microsoft .NET Framework 2.0 Service Pack 2
Microsoft .NET Framework 3.0 Service Pack 2
Microsoft .NET Framework 3.5 SP 1
Microsoft .NET Framework 4 Client Profile
Microsoft .NET Framework 4 Extended
Microsoft .NET Framework 4 Multi-Targeting Pack
Microsoft ASP.NET MVC 2
Microsoft ASP.NET MVC 2 -VWD Express 2010 Tools
Microsoft ASP.NET MVC 3
Microsoft ASP.NET MVC 4
Microsoft ASP.NET Web Pages
Microsoft Help Viewer 1.1
Microsoft NuGet for Visual Studio 2010
Microsoft Visual Studio 2010 ADO.NET Entity Framework Tools
Microsoft Visual Studio 2010 Service Pack 1
Microsoft Visual Studio 2010 Tools for Office Runtime (x86
Microsoft Visual Web Developer 2010 Express - ENU

Please advise.  Much appreciated.

Coordinator
Oct 22, 2012 at 5:53 PM
Do you have Visual Studio 2010 SP1 and the other prerequisites from Chapter 1 installed?

They're listed here: http://www.asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-1

From the error message, it looks like you don't have SQL Server Compact 4.0. Download is here:


From: 3v3rhart
Sent: Monday, October 22, 2012 8:08 AM
To: Jon Galloway
Subject: Music Store Tutorial, 4th Step / Error: Unable to find the requested .Net Framework Data Provider... [mvcmusicstore:400324]

From: 3v3rhart

Having a hell of a time, for quite some time (literally months, a couple hours each day) getting through Music Store tutorial. Without getting into detail of my trials and travails with the tutorial up until now, below outlines my current problem. Thanks for any input anyone might offer.

MvcMusicStore.Models.StoreController
Line 18: var genres = storeDB.Genres.ToList();
Error: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Environment: Brand new install of:
OS (XP)
and...
ASP.NET MVC3 with Tools (first)
ASP.NET MVC4 for Visual Studio 2010 (in this order)

(although when you choose to create new project in VWD 2010, there are only the choices of creating it either in MVC2 and MVC4 (MVC3 not an available option)

I think I have .NET Framework 4 installed (see below)

Control Panels / Add or Remove Programs / Currently Installed Programs
Microsoft .NET Framework 2.0 Service Pack 2
Microsoft .NET Framework 3.0 Service Pack 2
Microsoft .NET Framework 3.5 SP 1
Microsoft .NET Framework 4 Client Profile
Microsoft .NET Framework 4 Extended
Microsoft .NET Framework 4 Multi-Targeting Pack
Microsoft ASP.NET MVC 2
Microsoft ASP.NET MVC 2 -VWD Express 2010 Tools
Microsoft ASP.NET MVC 3
Microsoft ASP.NET MVC 4
Microsoft ASP.NET Web Pages
Microsoft Help Viewer 1.1
Microsoft NuGet for Visual Studio 2010
Microsoft Visual Studio 2010 ADO.NET Entity Framework Tools
Microsoft Visual Studio 2010 Service Pack 1
Microsoft Visual Studio 2010 Tools for Office Runtime (x86
Microsoft Visual Web Developer 2010 Express - ENU

Please advise. Much appreciated.

Oct 23, 2012 at 3:17 PM

Thank you Jon!

I seemed to have eight or more other SQL items installed from the ASP.net downloads site, but Compact 4 was not among them. Once installed website started right up (it took me weeks to get that answer)!

Thank you SO much. I'm very excited to move forward (it's been a bumpy road for me learning ASP / MVC with the last bump being my laptop was stolen, broken, and returned and I had to switch to another laptop more than a month ago and I've been struggling just to get back to where I was in the tutorial process on my original laptop).

Thanks again.

Dean Everhart

>
From: jongalloway
>
> Do you have Visual Studio 2010 SP1 and the other prerequisites from
> Chapter 1 installed?
> They're listed here:
> http://www.asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-1
>
>
From the error message, it looks like you don't have SQL Server Compact
> 4.0. Download is here:
> http://www.microsoft.com/en-us/download/details.aspx?id=17876
>
From: 3v3rhart
> Sent: Monday, October 22, 2012 8:08 AM
> To: Jon Galloway
> Subject: Music Store Tutorial, 4th Step / Error: Unable to find the
> requested .Net Framework Data Provider... [mvcmusicstore:400324]
>
>
From: 3v3rhart Having a hell of a time, for quite some time
> (literally months, a couple hours each day) getting through Music
> Store tutorial. Without getting into detail of my trials and travails
> with the tutorial up until now, below outlines my current problem.
> Thanks for any input anyone might offer.
> MvcMusicStore.Models.StoreController
> Line 18: var genres = storeDB.Genres.ToList();
> Error: Unable to find the requested .Net Framework Data Provider. It may
> not be installed. Environment: Brand new install of:
> OS (XP)
> and...
> ASP.NET MVC3 with Tools (first)
> ASP.NET MVC4 for Visual Studio 2010 (in this order) (although when you
> choose to create new project in VWD 2010, there are only the choices of
> creating it either in MVC2 and MVC4 (MVC3 not an available option) I
> think I have .NET Framework 4 installed (see below) Control Panels / Add
> or Remove Programs / Currently Installed Programs
> Microsoft .NET Framework 2.0 Service Pack 2
> Microsoft .NET Framework 3.0 Service Pack 2
> Microsoft .NET Framework 3.5 SP 1
> Microsoft .NET Framework 4 Client Profile
> Microsoft .NET Framework 4 Extended
> Microsoft .NET Framework 4 Multi-Targeting Pack
> Microsoft ASP.NET MVC 2
> Microsoft ASP.NET MVC 2 -VWD Express 2010 Tools
> Microsoft ASP.NET MVC 3
> Microsoft ASP.NET MVC 4
> Microsoft ASP.NET Web Pages
> Microsoft Help Viewer 1.1
> Microsoft NuGet for Visual Studio 2010
> Microsoft Visual Studio 2010 ADO.NET Entity Framework Tools
> Microsoft Visual Studio 2010 Service Pack 1
> Microsoft Visual Studio 2010 Tools for Office Runtime (x86
> Microsoft Visual Web Developer 2010 Express - ENU Please advise. Much
> appreciated.
>
>