将SQL Express 2008与VS2008一起使用?

时间:2023-01-06 08:18:00

I have the following installed:

我安装了以下内容:

  • VS 2008 SP 1
  • VS 2008 SP 1

  • ASP.NET MVC 1.0
  • ASP.NET MVC 1.0

  • SQL Express 2008
  • SQL Express 2008

  • SQL Management Studio 2008 (for connecting to SQL2008 Server)
  • 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