调用MS SQL存储过程（带链接连接） [英] Call MS SQL stored procedure (with linked connection)
问题描述
我已经找到两种方法从MS Access调用MSSQL存储过程：
1）通过查询
问题：每个客户端都必须配置DNS源代码，我不希望这样，管理工作太多......
2）编写VBA代码（例如使用ADO对象）
问题：我不想再建立连接。
我已将MS Access数据库与SSMA链接。为什么我不能使用这个连接来调用存储过程？
希望有一个简单的解决方案......提前致谢
祝你好运，
DR
编辑：MS Access 2007
I already found two ways to call an MSSQL stored procedure form MS Access:
1) Pass through query
Problem: Every client has to configure the DNS-source, I don''t want that, too much administration work...
2) Write VBA code (e.g. using ADO object)
Problem: I don''t want another connection.
I already linked the MS Access database with SSMA. Why can''t I use this connection to call a stored procedure?
Hopefully there''s an easy solution...Thanks in advance
Best regards,
D.R.
MS Access 2007
推荐答案
无人知道如何从MS访问调用MSSQL存储过程？ :(
什么是最好的方法？
祝你好运，
DR
Nobody knows how to call an MSSQL stored procedure from MS access? :(
What''s the best approach?
Best regards,
D.R.
据我所知，有5种方法可以通过Microsoft Access项目执行存储过程：
To the best of my knowledge, there are 5 Methods for Executing Stored Procedures via a Microsoft Access Project:
- 从Access数据库容器
- 来自其他存储过程
- 来自传递查询
- 使用命令对象从ADO
- 来自DAO
@Poweruser
你对DNS资源的具体含义是什么？ ''？
连接可以存储为PassThru查询本身的属性，所以我很难在这里看到问题。也许是因为我不知道你的意思是什么上面的松散术语DNS-source。
@Poweruser
这是什么？ 标准访问还是第三方？
您不会被视为新成员，但我们希望人们等待至少24碰撞线程前几小时。我们所有的志愿者都有生命，我们都没有保证每天都可以使用（周末通常特别安静 - 主要是因为问题和回答的问题要少得多）。
最后，但并非最不重要的是，欢迎来到字节！
@Poweruser
What do you mean specifically by ''the DNS-source''?
Connections can be stored as a property of the PassThru query itself, so I''m struggling to see a problem here. Maybe because I don''t know what you mean by the relatively loose term ''DNS-source'' above.
@Poweruser
What is this? Standard Access or something 3rd-party?
You wouldn''t be expected to know as a new member, but we like people to wait at least 24 hours before bumping a thread. All our volunteers have lives and none of us guarantees to be available every day (Weekends are generally particularly quiet - mainly because there are so much fewer questions and responses to deal with).
Last, but not least, Welcome to Bytes!
这篇关于调用MS SQL存储过程（带链接连接）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
