about sql server

[Tony Johansson]

Hello!

I have created a local sql server database(mfd file) in the following way.
1.Right click on a project and select Add->New Item
2.In the Add New Item dialog I pick the template Service-based Database andf
give it a name and this mdf file is stored in the
same project I created the database in. The created mdf file is also added
in the server explorer
3. I add a table and columns by using the server explorer to the created
database and all works fine.
4. I can connect to the database and I can store data in it and access the
data.
5.All this works fine.

Now to my question I deliver this application to some other person and when
he try to access the database he get the following error.
"The database 'BBB291C55FD82C293D1EF8A27B84B5E4_\MY DOCUMENTS\C# 2011
FORTS\TONYJOHANSSON\MODUL5\MODUL5\CARDGAMETESTAPP\BIN\DEBUG\BLACKJACK.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 'BBB291C55FD82C293D1EF8A27B84B5E4_\MY
DOCUMENTS\C# 2011"

So accoding to me the problem must be on his side because everything works
fine when I run it on my computer.
Do you agree with me ?
There are several document on the web talking about this problem "cannot be
opened because it is version 661. This server supports version 655 and
earlier. A downgrade path is not supported."

//Tony

 

[Jason Keats]

Hello!

I have created a local sql server database(mfd file) in the following way.
1.Right click on a project and select Add->New Item
2.In the Add New Item dialog I pick the template Service-based Database andf
give it a name and this mdf file is stored in the
same project I created the database in. The created mdf file is also added
in the server explorer
3. I add a table and columns by using the server explorer to the created
database and all works fine.
4. I can connect to the database and I can store data in it and access the
data.
5.All this works fine.

Now to my question I deliver this application to some other person and when
he try to access the database he get the following error.
"The database 'BBB291C55FD82C293D1EF8A27B84B5E4_\MY DOCUMENTS\C# 2011
FORTS\TONYJOHANSSON\MODUL5\MODUL5\CARDGAMETESTAPP\BIN\DEBUG\BLACKJACK.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 'BBB291C55FD82C293D1EF8A27B84B5E4_\MY
DOCUMENTS\C# 2011"

So accoding to me the problem must be on his side because everything works
fine when I run it on my computer.
Do you agree with me ?
There are several document on the web talking about this problem "cannot be
opened because it is version 661. This server supports version 655 and
earlier. A downgrade path is not supported."

//Tony

microsoft.public.sqlserver.programming

would be a more appropriate forum for your question.

However, the error message means exactly what it says. You are using a
later version of SQL Server than your friend. Too bad.

If you really want others to be able to use your database, then script
it! Or use the Compact Edition, or... (too many other alternatives to
mention).