AspnetDB has wrong version for VB?

 
50   50
Oct 04, 2010
 
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



630   99.9
Oct 04, 2010
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.

50   50
Oct 05, 2010
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