AspnetDB has wrong version for VB?

Hi,

Using VS2010 I get this error/exception when trying to login in Patterns 4 in action:
System.Data.SqlClient.SqlException was unhandled by user code
Class=20
ErrorCode=-2146232060
LineNumber=65536
Message=The database 'C:\USERS\PREBEN\DOCUMENTS\DOFACTORY PATTERNS 4.0 VB\PATTERNS IN ACTION\HOST.WCF.ACTIONSERVER\APP_DATA\ASPNETDB.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'C:\USERS\PREBEN\DOCUMENTS\DOFACTORY PATTERNS 4.0 VB\PATTERNS IN ACTION\HOST.WCF.ACTIONSERVER\APP_DATA\ASPNETDB.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Users\Preben\Documents\DoFactory Patterns 4.0 VB\Patterns In Action\Host.WCF.ActionServer\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.

Is it your code or my machine (vindows vista 32 bit)?

Regards Preben

Preben Carlsen, Oct 04, 2010

Reply 1

Hi Dan

Well, the suggested links didn't change much, so:

I created a database in my SQLServer with your script aspnetdb.sql
detached it from the SQLserver
copied the .mdf and .ldf to the app_data folder after renaming the other aspnetdb-files

and I got further in the investigation of the patterns

Regards Preben

Preben Carlsen, Oct 05, 2010

Reply 2

Preben:

You are the first user to report this particular error, so I am pretty confident it is a configuration issue on your machine. I suspect it is related to having both SQL Express 2005 and SQL Express 2008 installed.

I did some Googling and Binging around and these are some similar threads that may include a solution for you:

http://social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/43dea830-21ed-42fe-a89c-129c753cf120/
and
http://conceptdev.blogspot.com/2009/04/mdf-cannot-be-opened-because-it-is.html

I hope this points you in the right direction.

Dan McMillan, Oct 04, 2010