I have the following installed:
我安装了以下内容:
- VS 2008 SP 1
- ASP.NET MVC 1.0
- SQL Express 2008
- SQL Management Studio 2008 (for connecting to SQL2008 Server)
VS 2008 SP 1
ASP.NET MVC 1.0
SQL Express 2008
SQL Management Studio 2008(用于连接到SQL2008 Server)
When I right click on the App_Data Directory and click "Add New Item", if I choose SQL Server Database and name the .MDB file, I get an error:
当我右键单击App_Data目录并单击“添加新项”时,如果我选择SQL Server数据库并命名.MDB文件,则会收到错误消息:
Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL...
与SQL Server文件(* .mdf)的连接要求SQL Server Express 2005正常运行。请验证组件的安装或从URL下载...
What's up with that? Any help is appreciated...
那是怎么回事?任何帮助表示赞赏......
2 个解决方案
#1
Is it x64 Vista? This is a known issue. The workarounds suggest there might be a hotfix (http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957944).
是x64 Vista吗?这是一个已知的问题。解决方法建议可能有一个修补程序(http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957944)。
#2
This forum post suggests a fix. It says:
这篇论坛帖子提出了修复建议。它说:
Try deleting the directory SQLEXPRESS (Or better rename it say SQLEXPRESS_).
尝试删除目录SQLEXPRESS(或者更好地重命名为SQLEXPRESS_)。
It solved my problem. This directory is at following location...
它解决了我的问题。该目录位于以下位置......
C:\Documents and Settings[USERNAME]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
C:\ Documents and Settings [USERNAME] \ Local Settings \ Application Data \ Microsoft \ Microsoft SQL Server Data \ SQLEXPRESS
Also, make sure that you preference to the database is "sqlexpress" in the WMD (It should be , by default).
此外,确保您对数据库的首选项是WMD中的“sqlexpress”(默认情况下应该是)。
Look at http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1
请查看http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1
#1
Is it x64 Vista? This is a known issue. The workarounds suggest there might be a hotfix (http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957944).
是x64 Vista吗?这是一个已知的问题。解决方法建议可能有一个修补程序(http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957944)。
#2
This forum post suggests a fix. It says:
这篇论坛帖子提出了修复建议。它说:
Try deleting the directory SQLEXPRESS (Or better rename it say SQLEXPRESS_).
尝试删除目录SQLEXPRESS(或者更好地重命名为SQLEXPRESS_)。
It solved my problem. This directory is at following location...
它解决了我的问题。该目录位于以下位置......
C:\Documents and Settings[USERNAME]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
C:\ Documents and Settings [USERNAME] \ Local Settings \ Application Data \ Microsoft \ Microsoft SQL Server Data \ SQLEXPRESS
Also, make sure that you preference to the database is "sqlexpress" in the WMD (It should be , by default).
此外,确保您对数据库的首选项是WMD中的“sqlexpress”(默认情况下应该是)。
Look at http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1
请查看http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1