Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : 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
 
Old September 6th, 2012, 06:40 AM
Registered User
Points: 36, Level: 1
Points: 36, Level: 1 Points: 36, Level: 1 Points: 36, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Default SQL Server 2008 Express problem

Hi Imar,

Please could you advise me on the following issue:

After working through your book, I have created a site using a visual web developer 2010 Express with SQL Server 2008 Express and SP1, on Windows XP 32 bit. Everything worked fine. However, I now need to make some adjustments and the computer I am now using has the Windows 7 Enterprise N 64 bit operating system.
I downloaded visual web developer 2010 express using web platform installer, then opened my site which displayed in the Solution Explorer. However, when I opened Database Explorer and refreshed my database connections my two databases showed the following error window:

The database 'C:\WYKEHAMGALLERY\RELEASE\APP_DATA\ASPNETDB.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
Could not open new database 'C:\WYKEHAMGALLERY\RELEASE\APP_DATA\ASPNETDB.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\WykehamGallery\Release\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Can you tell me what I have done wrong?

Many Thanks
 
Old September 6th, 2012, 06:52 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 Chris,

Looks like a SQL Server version issue. 661 is SQL Server 2008 R2, while 655 is the older SQL Server 2008.

What you could so is this:

1. Through Programs and Features, uninstall SQL Server Express 2008
2. Through the Web Platform Installer, install SQL Server Express 2008 R2

Alternatively, you could install SQL Server 2008 R2 side by side. However, that means you need to give it a different instance name (such as Sql2008R2Express) and then update your connection strings and settings in Visual Studio (Tools | Options | Database Tools | Data Connections | SQL Server Instance Name).

Hope this helps, but let me know if it doesn't.

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!
 
Old September 6th, 2012, 08:13 AM
Registered User
Points: 36, Level: 1
Points: 36, Level: 1 Points: 36, Level: 1 Points: 36, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Default SQL Server Express 2008 problem

Hi Imar,

Thanks for your reply. I have uninstalled SQL Server 2008 as instructed and now have SQL Server 2008 Express R2. However, when trying to refresh my databases in Database Explorer I now get the following mesage:

Server Explorer Error

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.

Do you have any ideas?

Many Thanks
 
Old September 6th, 2012, 09:40 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

Take a look at this post and follow the links that are mentioned: Problem using SQL Server Express 2008

You may need to delete a folder referred to in those posts.

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!
 
Old September 25th, 2012, 06:04 AM
Authorized User
Points: 100, Level: 1
Points: 100, Level: 1 Points: 100, Level: 1 Points: 100, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 26
Thanks: 0
Thanked 1 Time in 1 Post
Default

I had problems with this as well, but they were solved. My Main problem appeared because apparently SQL Express 2008 isn't compatible with windows 7, so you need to install SQL Express 2008 SP3 instead. Now it works fine, and I can crack on with my learning.
Thank you for this awesome book!
 
Old September 25th, 2012, 07:11 PM
Registered User
Points: 36, Level: 1
Points: 36, Level: 1 Points: 36, Level: 1 Points: 36, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thanks Imar, I deleted the C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory. I then did a restart.

Many Thanks,

Chris
 
Old September 27th, 2012, 04:57 AM
Authorized User
Points: 100, Level: 1
Points: 100, Level: 1 Points: 100, Level: 1 Points: 100, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 26
Thanks: 0
Thanked 1 Time in 1 Post
Default

I thought that I had fixed this but apparently I havent :( It's really annoying that I have to delete that hidden file in the appdata and then restart my computer every time.
Is there not a fix that would fix it on a more permanent scale?
Thank you
 
Old September 27th, 2012, 10:27 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

Not that I know; I thought the fixed would solve the problem for good...

Try contacting Microsoft Support. SQL Server is a fully supported product so they should be able to help you out.

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!
 
Old September 27th, 2012, 11:12 AM
Authorized User
Points: 100, Level: 1
Points: 100, Level: 1 Points: 100, Level: 1 Points: 100, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 26
Thanks: 0
Thanked 1 Time in 1 Post
Default

Oh ok , thank you.
I'll see what happens next time I restart and then take it from there
 
Old September 28th, 2012, 06:57 AM
Authorized User
Points: 100, Level: 1
Points: 100, Level: 1 Points: 100, Level: 1 Points: 100, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 26
Thanks: 0
Thanked 1 Time in 1 Post
Default

It's still not working.
Do you think that I should uninstall SQL Server 2008 express and install 2012 instead?




Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem using SQL Server Express 2008 floridaguy BOOK: Beginning ASP.NET 4 : in C# and VB 4 August 19th, 2011 09:35 AM
Synchronization between SQL 2008 Express on local machine and SQL hosting server avidan ASP.NET 4 General Discussion 0 December 29th, 2010 12:31 PM
SQL Server 2008 vs Express ewingf BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 5 May 20th, 2010 04:52 PM
Help With Visual Studio 2008 & SQL Server 2005 Express Rambo Visual Studio 2008 3 December 21st, 2009 12:08 PM
Installing SQL Server 2008 Express Edition with Tools Kevin7777 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 March 8th, 2009 05:14 AM





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