Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #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
  #2 (permalink)  
Old March 27th, 2013, 04:44 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
  #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
  #4 (permalink)  
Old March 27th, 2013, 05:28 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
  #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
  #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?
  #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.
  #8 (permalink)  
Old April 2nd, 2013, 03:59 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
  #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#
  #10 (permalink)  
Old April 3rd, 2013, 03:02 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!




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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.