需要此错误的帮助 [英] need help for this error

问题描述

大家好，
我需要向应用程序中添加数据库，如果执行此操作，它将显示此错误

与sql server数据库文件(.mdf)的连接需要在本地计算机上安装并运行sql server 2005 express或sql server 2005 express.可以在以下URL中提供当前版本的sql server express:
http://www.go.microsoft.com/fwlink/?linkid=125883"

我该怎么办?

hi guys,
i need to add a database to my application, and if i do this i it show me this error

"connections to the sql server database files (.mdf) require sql server 2005 express or sql server 2005 express to be installed and running on the local computer.the current version of sql server express can be downlaoded in the following URL:
http://www.go.microsoft.com/fwlink/?linkid=125883"

What can i do?

推荐答案

您可以:
1)单击链接并安装Sql Server 2008 R2 Express版.但是，如果这样做，为什么要使用Access数据库?为什么不使用SQL呢?
2)尝试使用OleDBConnection-您不需要为此使用SQL Server.连接字符串将类似于以下内容:

You could:
1) Follow the link and install Sql Server 2008 R2 Express edition. But if you do that, why use an Access database? Why not use a SQL one?
2) Try using an OleDBConnection - you shouldn''t need SQL Server for that. The connection string will be something along the lines of:

string ConnStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyDatebases\abc.mdb;Jet OLEDB:Database Password=password";

但是您应该可以从VS中的服务器资源管理器中获取该信息.

But you should be able to get that from the Server Explorer in VS.

我认为您需要在计算机上安装SQL Server，或者如果您以前已经安装了修复它，或者卸载，然后再次重新安装.

以下链接可能会帮助您完成安装过程，

[1] 如何:安装SQL Server 2008 R2(安装程序) [^ ]
[2] 如何安装SQL Server 2005-快速指南 [ ^ ]
[3] 如何:安装SQL Server 2000-基本本地安装 [^ ]

希望对您有所帮助:)

I think you would need to install SQL server on your machine or if you have previously installed repair it or uninstall and then re-install again.

Following links might help you to go through the installation process,

[1] How to: Install SQL Server 2008 R2 (Setup)[^]
[2] How to Install SQL Server 2005 - A Quick Guide[^]
[3] HOW TO: Install SQL Server 2000 - Basic Local Installation[^]

Hope it helps :)

看看这个

这篇关于需要此错误的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！