本文介绍如何从Visual FoxPro程序中将Visual FoxPro数据源添加为SQL Server的链接服务器，并进行查询。通过sp_addlinkedserver存储过程，可以创建允许访问OLE DB数据源的分布式异构查询的链接服务器。
Add a Visual FoxPro database to SQL Server as a linked server
09/08/2020
2 分钟可看完
本文内容
This article introduces how to programmatically add and query a Visual FoxPro data source as a linked server from Visual FoxPro.
Original product version: Visual FoxPro
Original KB number: 199131
Summary
SQL Server 7.0 and SQL Server 2000 allows the addition of external data sources as linked servers. This feature provides access to distribute, heterogeneous queries against OLE DB data sources. This article shows how to programmatically add and query a Visual FoxPro data source as a linked server from Visual FoxPro.
More information
sp_addlinkedserver is a new stored procedure introduced in SQL Server 7.0 and SQL Server 2000. sp_addlinkedserver creates a linked server, which allows access to distribute, heterogeneous queries against OLE DB data sources.
The syntax f
最低0.47元/天 解锁文章
1196
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
