ASP .Net MVC 4，键'attachdbfilename'的值无效 [英] ASP .Net MVC 4, Invalid value for key 'attachdbfilename'

问题描述

我是asp.net mvc 4的新手

下面是我的连接字符串

<add name="MovieDBContext"
     connectionString="Data Source=(LocalDB)\v11.0;
                       Initial Catalog=Movies;
                       AttachDbFilename=|DataDirectory|\Movies.mdf;
                       Integrated Security=True" 
     providerName="System.Data.SqlClient" />

尝试通过url访问特定控件时出现以下错误

键"attachdbfilename"的值无效.

错误本身说这是由于错误的连接字符串引起的，但我找不到问题出在哪里. 我正在使用VisualStudio Management Studio.

解决方案

尝试将您的连接字符串更改为:

<add name="MovieDBContext"
    connectionString="Data Source=.;Initial Catalog=Movies;AttachDbFilename=|DataDirectory|\Movies.mdf;Integrated Security=True"
    providerName="System.Data.SqlClient" />

将数据源更改为:Data Source=.;或Data Source=.\SQLEXPRESS;

在那之后，您需要配置对App_Data的访问权限. 对于Win7，在添加用户网络服务"属性中的安全性"选项卡上.

发现了类似的问题:

asp.net mvc密钥"attachdbfilename"的值无效

或者我认为，这可能只是您的连接字符串中的错字.因为您没有(LocalDB)\ v11 的转义字符.

尝试编写Data Source=(LocalDB)\\v11;

I'm new to asp.net mvc 4

Below is my connection string

<add name="MovieDBContext"
     connectionString="Data Source=(LocalDB)\v11.0;
                       Initial Catalog=Movies;
                       AttachDbFilename=|DataDirectory|\Movies.mdf;
                       Integrated Security=True" 
     providerName="System.Data.SqlClient" />

I'm getting following error when trying to access a particular control by url

Invalid value for key 'attachdbfilename'.

The error itself says it is due to a wrong connection string,but I cant find where the problem is. I'm using VisualStudio Management Studio.

解决方案

Try changing your connection string to:

<add name="MovieDBContext"
    connectionString="Data Source=.;Initial Catalog=Movies;AttachDbFilename=|DataDirectory|\Movies.mdf;Integrated Security=True"
    providerName="System.Data.SqlClient" />

Change Data Source to : Data Source=.; or Data Source=.\SQLEXPRESS;

After that, you need to configure access right to App_Data. For Win7, On Security tab in properties Add user network Service with full right.

Found similar question:

asp.net mvc Invalid value for key 'attachdbfilename'

Or in my opinion, it might be just a typo in your connection string. Because you don't have escape character for (LocalDB)\v11.

Try writing Data Source=(LocalDB)\\v11;

这篇关于ASP .Net MVC 4，键'attachdbfilename'的值无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！