将Access 2007连接到SQL Server 2008数据库 [英] Connect Access 2007 to SQL Server 2008 Database

问题描述

我已经看到许多类似问题的答案.我没有在网上看到很多人问过看似简单的问题如何将Access 2007连接到SQL Server 2008数据库"-但是所有答案都描述了如何从Access 2007迁移到sql server 2008数据库，或者它们描述了如何将Access 2007连接到sql server 2005数据库.我找不到解决我问题的任何简单方法(可能这对许多其他人来说都是个问题).这是一个问题(过分强调，很抱歉):

I've seen numerous answers to similar questions like this one. I haven't seen on the web many people have asked the seemingly simple question "How do I connect Access 2007 to an SQL server 2008 database" - but all of the answers describe how you can migrate from access 2007 to an sql server 2008 database, or they describe how to connect access 2007 to an sql server 2005 database. I can't find any simple solution to my problem (and probably this is a problem for many others). Here is the question (sorry for the over emphasis):

如何从Access 2007连接到sql server 2008数据库(我的意思是2008，而不是2005 :)?再次道歉，不过这是一个非常简单的问题，我认为应该是一个非常简单的任务，是的，...不可能！ 我尝试运行sql服务器浏览器，启用管道，TCP等，但是似乎无法识别2008 SQLEXPRESS！请有人帮忙. 彼得

How do I connect to an sql server 2008 database (and I mean 2008, not 2005 :) ) from access 2007? Apologies again for the over emphasis, but this very simple question, and what I thought should be a very simple task seems, yes, ... impossible! I tried running sql server browser, enabling pipes, TCP etc, but it seems that with 2008 SQLEXPRESS just isn't recognised! Please can someone help with this. Peter

推荐答案

伙计们-您真的应该在发出随机答案之前检查它是否有效.运行Access项目并发现它实际上并不容易连接到SQL 2008大约需要一分钟.

Guys - you really should check whether this works before firing off random answers. It takes all of about a minute to run up an Access project and discover that it doesn't actually connect to SQL 2008 easily.

使用项目而不是ODBC的原因很多，但是这里有一些原因:

There are plenty of reasons to use projects instead of ODBC, but here's a few:

• 不能保证部署机器上DSN的存在
• 网络流量-默认情况下不执行传递查询
• 对存储过程的支持不佳

假设已启用适当的协议，解决方案是转到数据链接对话框的高级"选项卡，然后删除网络库"设置中的值.

Assuming that appropriate protocols have been enabled, the solution is to go to the Advanced tab of the data link dialog and delete the value in the Network Library setting.

这篇关于将Access 2007连接到SQL Server 2008数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！