Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 4 24-Hour Trainer
This is the forum to discuss the Wrox book ASP.NET 4 24-Hour Trainer by Toi B. Wright; ISBN: 978-0-470-59691-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 4 24-Hour Trainer 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
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 22nd, 2010, 01:53 PM
Registered User
 
Join Date: Aug 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Question Wrong mdf version?

In the "Step by Step" section for Chapter 18 - Using the ADO.NET Entity Framework. When I click on OK in Step #15, I get an error saying that the MDF file is version 655. This server supports version 612 and earlier.

How can I get a version of the file that will work. I have Visual Web Developer 2010 Express.

Thank You
  #2 (permalink)  
Old August 23rd, 2010, 11:51 AM
Authorized User
Points: 66, Level: 1
Points: 66, Level: 1 Points: 66, Level: 1 Points: 66, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2010
Location: Dallas, TX
Posts: 18
Thanks: 0
Thanked 1 Time in 1 Post
Default Please use SQL Server 2008 Express

All of the database files were created using SQL Server 2008 Express. You can download a free copy from - http://www.microsoft.com/express/Database/.

Regards,


Toi Wright
  #3 (permalink)  
Old August 25th, 2010, 05:43 PM
Registered User
 
Join Date: Aug 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Thanks!

Thanks for the info Toi!
  #4 (permalink)  
Old August 31st, 2010, 03:50 PM
Registered User
 
Join Date: Aug 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Toi,

I still need some help. I have tried SQL Server 2008 Express both with and without the R2. I keep getting this message:

Connections to SQL Server database files require Sql Server 2005 Express or 2008 Express to be installed and running.

I am on a notebook with:
Windows 7 Ultimate
Visual Studio 2010 Ultimate
Microsoft Visual Web Developer 2010 Express
SQL Server 2008 Express
- I downloaded SQL Server from the Express web page, but when
I go to "about", it says nothing about being an Express version, is that normal?

I have tried every combination I can think of over the last 5 or 6 days, and simply cannot add either your MDF file or a database I create on my own to my projects. Any idea what I am doing wrong?

Thank you again for your time.

- Richard M. Garber
  #5 (permalink)  
Old September 1st, 2010, 11:12 AM
Authorized User
Points: 66, Level: 1
Points: 66, Level: 1 Points: 66, Level: 1 Points: 66, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2010
Location: Dallas, TX
Posts: 18
Thanks: 0
Thanked 1 Time in 1 Post
Default Running SQL Server

Are you sure that SQL Server is running? To check, follow these steps:

1. Right-click the task bar and select Start Task Manager.
2. Click on the Services tab.
3. Look for MSSQL $SQLEXPRESS and make sure that it is not stopped.
4. If it is stopped, right-click it and select Start Service.

Regards,


Toi B Wright
  #6 (permalink)  
Old September 4th, 2010, 04:32 PM
Registered User
 
Join Date: Aug 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Toi,

I have verified that the service is running. The service is listed as
SQL Server (SQLEXPRESS)

This time I installed sql server 2008 R2 express with all the default settings.

Now, when I attempt to add a sql data source in visual web developer, I am getting:

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

So it sounds to me like visual web recognized that I do in fact have SQL installed and running as a process on my machine. What does it mean by "User instance"?


Believe it or not I got it working. I followed the advice on
http://blog.krisvandermast.com/Faile...lBeClosed.aspx

After my new install, I had to make sure the process was started with LocalService, which it wasn't, then I had to manually delete a folder
in my user's appdata called sqlserverexpress, which apparently was holding some incorrect data from previous installs.
I believe that the installer should handle this for the end user.

Now I have added your recipes.mdf file to my project and can continue with the lesson!!

BTW Toi, is there a quick way to determine a correct connection string, does Visual Studio have a way to find it?

Thanks again!

- Richard

Last edited by rgarber; September 4th, 2010 at 05:17 PM.
  #7 (permalink)  
Old September 5th, 2010, 11:32 AM
Authorized User
Points: 66, Level: 1
Points: 66, Level: 1 Points: 66, Level: 1 Points: 66, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2010
Location: Dallas, TX
Posts: 18
Thanks: 0
Thanked 1 Time in 1 Post
Default

Richard,

Have you installed the SQL Server Management Studio, http://www.microsoft.com/downloads/d...isplaylang=en? It is free and it will allow you to manage your SQL Server instance. From your error message it sounds like you now have a rights issue. You can use SQL Server Management Studio to view who has rights. Also, you may want to view your event log to see more detailed error information.

I hope this helps,


Toi B Wright
  #8 (permalink)  
Old October 1st, 2010, 12:25 AM
Registered User
 
Join Date: Oct 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

An MDF file is an Alcohol 120 file. I could be wrong, but I think Daemon Tools will open it up. If not, just rename it to an .iso and see if that works. Or change the .mds file to that. I can't remember which one is the actual disk image and which is the media descriptor file. It's one or the other, whichever one is bigger.

_________

SEO services | PSD to HTML
  #9 (permalink)  
Old October 10th, 2010, 04:05 PM
Friend of Wrox
Points: 1,749, Level: 16
Points: 1,749, Level: 16 Points: 1,749, Level: 16 Points: 1,749, Level: 16
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2007
Location: San Diego, CA, USA.
Posts: 477
Thanks: 10
Thanked 19 Times in 18 Posts
Default

I've never heard of Daemon Tools, what do you like about it. For the most part I've stuck to SQL Server Management Studio just because there are so many people who use SSMS and are familiar with it. Support has always been a big deal for me.
__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.
 


Thread Tools
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
TheBeerHouse.mdf BauwensER BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 7 February 9th, 2010 03:38 PM
ASPNETDB.mdf Will BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 April 27th, 2009 02:07 PM
Passwords from version 1 to version 2 Maxxim BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 3 February 6th, 2007 06:49 PM



All times are GMT -4. The time now is 05:28 AM.


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