Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4.5 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4.5: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-31180-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4.5 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 27th, 2013, 04:39 PM
Registered User
Points: 40, Level: 1
Points: 40, Level: 1 Points: 40, Level: 1 Points: 40, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2013
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default SQL problems, chapter 12

I get the following error when I try to open up folders/files in the Planetwrox.mdf folder:

"Microsoft.SqlServer.Management.Sdf.Sfc Version=10.0.0.0, Culture=neutral, PublicKey Token=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. "

I was progressing nicely through the book but this has stumped me & I cannot do any database stuff.

Can anyone advise on how to resolve this? Thanks
Reply With Quote
  #2 (permalink)  
Old March 27th, 2013, 04:44 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Sounds like a broken installation of SQL Server. Are you sure you're adding an MDF file? Sdf seems to suggest SQL Server compact.

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #3 (permalink)  
Old March 27th, 2013, 05:09 PM
Registered User
Points: 40, Level: 1
Points: 40, Level: 1 Points: 40, Level: 1 Points: 40, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2013
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default SQL error Chapter 12

I have moved Planetwrox.mdf to Database Explorer. Its at that point that I cannot open up the folders e.g. Tables in Database explorer and get that error when I try.

So should I reinstall SQl server? If so can you suggest a link. I tried to do that from Microsoft website so may have not done it properly.

Thanks
Reply With Quote
  #4 (permalink)  
Old March 27th, 2013, 05:28 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

See page 424 and further for more info on installing Local DB and/or SQL Server Express.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #5 (permalink)  
Old April 1st, 2013, 09:17 AM
Registered User
Points: 40, Level: 1
Points: 40, Level: 1 Points: 40, Level: 1 Points: 40, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2013
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default Another query

Thanks Imar for previous advice.

I downloaded SQL Server 2008 R2. SQL Server 2008 would not download successfully.

I managed to progress further through chapter 12. However I am now doing the Creating Tables exercise later in chapter 12 and when I try to Add New Table in the Planet Wrox website I get this message:

"This server version is not supported. Only servers up to Microsoft SQL Server 2008 are supported".

Are you able to advise me on getting round this problem?

Thanks
Reply With Quote
  #6 (permalink)  
Old April 1st, 2013, 09:53 AM
Authorized User
Points: 118, Level: 2
Points: 118, Level: 2 Points: 118, Level: 2 Points: 118, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2013
Posts: 29
Thanks: 1
Thanked 1 Time in 1 Post
Default

What version of VS are you using?
Reply With Quote
  #7 (permalink)  
Old April 1st, 2013, 10:14 AM
Registered User
Points: 40, Level: 1
Points: 40, Level: 1 Points: 40, Level: 1 Points: 40, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2013
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default

I am using Microsoft Visual Web Developer 2010 Express.

My PC is using Windows 7.

I can access database tables, having done SQL queries on PlanetWrox.mdf files
earlier in chapter 12 - these having been already created for users of the book.

What I cannot do now is create new tables when I am in my Planet Wrox website.
Reply With Quote
  #8 (permalink)  
Old April 2nd, 2013, 03:59 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

Did you post in the right forum? This book deals with Visual Studio 2012 and SQL Server 2012. However, you mention Visual Studio 2010 and SQL Server 2008.

If you have the ASP.NET 4 version of the book, you need other page references for installing the required sofware.

>> What I cannot do now is create new tables when I am in my Planet Wrox website.

That seems to suggest you're using SQL 2012 under the hood? A lot of the functionality can no longer be access directly in Visual Studio. Instead, you need to use SQL Server Management Studio to create tables and the like.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #9 (permalink)  
Old April 2nd, 2013, 03:48 PM
Registered User
Points: 40, Level: 1
Points: 40, Level: 1 Points: 40, Level: 1 Points: 40, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2013
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Sorry, I should be on the ASP.NET 4 forum.

Anyway, I am still struggling to add new tables in VWD.

I have downloaded SQL Server Management studio.

Yes I have SQL Server 2012 as well as SQL Server 2008 R2 on my PC. the former because I have used Visual Studio 2012 as I have been trying to learn C#
Reply With Quote
  #10 (permalink)  
Old April 3rd, 2013, 03:02 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

It sounds like you're still using SQL Server 2012 as there are limitations as the type of objects you can create and manage from within VS for that version of SQL Server.

What are the names of your SQL Server instances and versions? Is .\Express SQL 2008 or 2012? Also, in VS, what do you have under Tool | Options | Database Tools | Data Connections | SQL Server Instance Name?

If it keeps failing, just SQ: Server Management Studio to manage the tables.

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with chapter 12 happyandstable BOOK: Beginning ASP.NET 4 : in C# and VB 5 March 7th, 2012 11:28 AM
Chapter 12 SQL File? Any SQL files? ripcurlksm BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 June 20th, 2008 06:49 PM



All times are GMT -4. The time now is 05:14 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.