I am getting the error below during page load for my LINQTOSQL app.


The database cannot be opened because it is version 655. This server
supports version 612 and earlier. A downgrade path is not supported. The
sales .mdf file is in my App_Data folder. Will appreciate any suggestions

Alex. O. Koranteng wrote:
> I am getting the error below during page load for my LINQTOSQL app.
>
>
> The database cannot be opened because it is version 655. This server
> supports version 612 and earlier. A downgrade path is not supported. The
> sales .mdf file is in my App_Data folder. Will appreciate any suggestions

It appears you have a SQL 2008 data file, on a machine with SQL 2005.
You should download SQL 2008 Express and try to open the file.

--
Mike

Mike,

Thanks for the info. I will download SQL 2008 Express. I have SQL Server 208
developer edition. Will that do it and should should I do a restore and set
up a connectionstring in web.config.




"Family Tree Mike" wrote:

> Alex. O. Koranteng wrote:
> > I am getting the error below during page load for my LINQTOSQL app.
> >
> >
> > The database cannot be opened because it is version 655. This server
> > supports version 612 and earlier. A downgrade path is not supported. The
> > sales .mdf file is in my App_Data folder. Will appreciate any suggestions
>
> It appears you have a SQL 2008 data file, on a machine with SQL 2005.
> You should download SQL 2008 Express and try to open the file.
>
> --
> Mike
>

Hi Alex,

Mike is right. We need SQL Server 2008 Express to open the database file
(.mdf). The issue occurs when we attach SQL Server 2008 database files to
SQL Server 2005 instance.
http://forums.asp.net/t/1413516.aspx
http://forums.asp.net/t/1349092.aspx

After we attach a SQL Server 2005 or SQL Server 2000 database to SQL Server
2008, the database is then automatically upgraded to SQL Server 2008.
Please see: http://msdn.microsoft.com/en-us/library/ms189625.aspx.

When we connect to the database placed in App_Data folder, the database is
attached to a SQL Server Express user instance, which is a new feature
provided from SQL Server 2005 Express and not supported by other editions
of SQL Server, like Developer or Enterprise.

After install the SQL Server 2008 Express, its instance name should be
different from the original SQL Server 2005 Express instance name, so
please go to Microsoft SQL Server 2008 --> Configuration Tools --> SQL
Server Configuration Manager --> SQL Server Services, check the name of the
SQL Server 2008 Express instance and then modify the connection string in
your application’s Web.config file. Meanwhile, please remember to make a
copy of the your database file and database log file to avoid any data lost.

If you have any questions, please feel free to let me know.

Have a nice day, Alex!


Best Regards,
Lingzhi Sun
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(E-Mail Removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#notifications.

MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Linghzi,

Which version of SQL Server 2008 Express edition do I download. Do I
download the X64 or X86 version. I am using Vista Premium edition and my
system type is a 32 bit operating system

Thanks

"Lingzhi Sun [MSFT]" wrote:

> Hi Alex,
>
> Mike is right. We need SQL Server 2008 Express to open the database file
> (.mdf). The issue occurs when we attach SQL Server 2008 database files to
> SQL Server 2005 instance.
> http://forums.asp.net/t/1413516.aspx
> http://forums.asp.net/t/1349092.aspx
>
> After we attach a SQL Server 2005 or SQL Server 2000 database to SQL Server
> 2008, the database is then automatically upgraded to SQL Server 2008.
> Please see: http://msdn.microsoft.com/en-us/library/ms189625.aspx.
>
> When we connect to the database placed in App_Data folder, the database is
> attached to a SQL Server Express user instance, which is a new feature
> provided from SQL Server 2005 Express and not supported by other editions
> of SQL Server, like Developer or Enterprise.
>
> After install the SQL Server 2008 Express, its instance name should be
> different from the original SQL Server 2005 Express instance name, so
> please go to Microsoft SQL Server 2008 --> Configuration Tools --> SQL
> Server Configuration Manager --> SQL Server Services, check the name of the
> SQL Server 2008 Express instance and then modify the connection string in
> your application’s Web.config file. Meanwhile, please remember to make a
> copy of the your database file and database log file to avoid any data lost.
>
> If you have any questions, please feel free to let me know.
>
> Have a nice day, Alex!
>
>
> Best Regards,
> Lingzhi Sun
> Microsoft Online Community Support
>
> Delighting our customers is our #1 priority. We welcome your comments and
> suggestions about how we can improve the support we provide to you. Please
> feel free to let my manager know what you think of the level of service
> provided. You can send feedback directly to my manager at:
> (E-Mail Removed).
>
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/en-us/subs...#notifications.
>
> MSDN Managed Newsgroup support offering is for non-urgent issues where an
> initial response from the community or a Microsoft Support Engineer within
> 2 business day is acceptable. Please note that each follow up response may
> take approximately 2 business days as the support professional working with
> you may need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations that require urgent,
> real-time or phone-based interactions. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/en-us/subs.../aa948874.aspx
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

HI Alex,

As you are using Windows Vista 32-bit version, we need to install SQL
Server 2008 Express x86 version. The download link is,
http://www.microsoft.com/downloads/d...85d-508b-45c8-
9fd3-118edd8e6fff&displaylang=en.

Besides, to work with SQL Server 2008 in Visual Studio 2008 IDE, we need to
install Visual Studio 2008 SP1. The download link is,
http://www.microsoft.com/downloads/d...648-7106-44A7-
9649-6D9F6D58056E&displaylang=en


Have a nice day!


Best Regards,
Lingzhi Sun
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(E-Mail Removed).

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================