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