Visual Studio 2010 抱怨数据库版本

发布于 2024-11-05 19:40:35 字数 1490 浏览 10 评论 0原文

又是美好的一天。

好吧，我想做的是将数据库保留在 App_Data 文件夹中以便于使用，现在我认为这很容易：将数据库复制到文件夹中并更改连接字符串。但是当我尝试时，我收到了可怕的版本错误：

数据库 'C:\用户\GUÐMUNDUR\桌面\测试\测试\APP_DATA\IRIS2.MDF' 打不开，因为是版本 661.此服务器支持版本655及更早版本。降级路径不是支持。无法打开新数据库 'C:\USERS\GUÐMUNDUR\DESKTOP\TEST\TEST\APP_DATA\IRIS2.MDF'。创建数据库被中止。一次尝试附加一个自动命名的数据库文件 C:\Users\Guðmundur\Desktop\Test\Test\App_Data\IRIS2.mdf 失败的。同名数据库存在，或者指定的文件不存在打开，或者位于 UNC 共享上。

现在我想知道是否有人可以提出解决方案，我可以通过 SQL 脚本重新创建数据库，所以这没有问题，并且那里没有重要的（尚未）信息。

有什么想法吗？

下面是连接字符串：

  <connectionStrings>
    <add name="ApplicationServices"
         connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|IRIS2.mdf;User Instance=true"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

我使用的解决方案

我进入 SQL Server Management Studio 并将数据库附加到那里，同时将其保留在 App_Data 文件夹中。然后我进入 Visual Studio，创建一个新的数据连接，创建后我单击它并进入它的“属性”选项卡，从连接字符串中选择所有内容，并用它替换我原来的内容。

所以连接字符串现在看起来像这样：

  <connectionStrings>
    <add name="ApplicationServices"
          connectionString="Data Source=WODAN;Initial Catalog=IRIS;Integrated Security=True"
          providerName="System.Data.SqlClient" />
  </connectionStrings>

以下是附件过程的说明（由 Ladislav Mrnka 提供） msdn.microsoft.com/en-us/library/ms190209.aspx

感谢大家的投入，特别感谢 Ladislav 帮助我完成任务。

原文

Good day once more.

Okay so what I want to do is to keep my database in the App_Data folder for ease of use, now I thought this would be easy: Copy the database into the folder and change the connection string. But when I try that I get the horrible version error:

The database
'C:\USERS\GUÐMUNDUR\DESKTOP\TEST\TEST\APP_DATA\IRIS2.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:\USERS\GUÐMUNDUR\DESKTOP\TEST\TEST\APP_DATA\IRIS2.MDF'.
CREATE DATABASE is aborted. An attempt
to attach an auto-named database for
file
C:\Users\Guðmundur\Desktop\Test\Test\App_Data\IRIS2.mdf
failed. A database with the same name
exists, or specified file cannot be
opened, or it is located on UNC share.

Now I was wondering if anyone can suggest a solution to this, I can recreate the database via the SQL script so there is no problem with that and there is no important (yet) information there.

Any ideas?

Here is the connection string:

  <connectionStrings>
    <add name="ApplicationServices"
         connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|IRIS2.mdf;User Instance=true"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

The solution I used

I went into the SQL Server Management Studio and attached the database there while keeping it in the App_Data folder. Than I went into Visual Studio, created a new Data Connection and after it was created I clicked on it and went into Properties tab for it and selected everything from the Connection String and replaced what I originally had with it.

So the connection string looks like this now:

  <connectionStrings>
    <add name="ApplicationServices"
          connectionString="Data Source=WODAN;Initial Catalog=IRIS;Integrated Security=True"
          providerName="System.Data.SqlClient" />
  </connectionStrings>

Here are the instructions for the attachment process (as supplied by Ladislav Mrnka)
msdn.microsoft.com/en-us/library/ms190209.aspx

Thanks to everyone for their input and special thanks for Ladislav for helping me through out.

分享到QQ

分享到微博