tsql - SQL Server 链接服务器错误

Question

我在 Windows Server 2003 上使用 SQL Server 2008。我想使用链接服务器打开 Visual Foxpro DBF 文件，使用驱动程序 Microsoft OLD DB Provider for Visual Foxpro 来自 SQL Server 2008 链接服务器功能。

当我使用 Microsoft OLD DB Provider for Visual Foxpro 建立链接服务器连接时，打开 Foxpro DBF 文件时，遇到以下错误，请问有什么问题吗？

Can not retrieve required data from this request (Microsoft.SqlServer.Management.Sdk.Src)

Meeting exception when executing Transact-SQL or batch (Microsoft.SqlServer.ConnectionInfo)

Error from Microsoft OLD DB Provider interface "VFPOLEDB" of linked server "DBFServer", access is defined.

Can not retrieved required interface "IID_IDBSchemaRowset" from OLE DB interface "VFPOLEDB" of linked server "DBFServer"

(Microsoft SQL Server 错误 7399)

问候，
乔治

Answer 1

在 VFPOLEDB 提供程序上选中“Allow Inprocess”:

参见 Cindy Winegarden 在 http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/e54d20dd-b65b-4cff-9349-6499e6e069e2 上的回答如何做到这一点。

编辑:这是答案的相关部分:

Here's what Stepahnie posted to her thread in the microsoft.public.data.oledb NNTP newsgroup on April 10:

"Finally, I found an option ' Allow inprocess' in linked server -> providers -> VFPOLEDB in MSSQL2005. With enable this option, I can connect to vfp with oledb. While diabling this option, it works only 50% with successful connection....

And I have another MSSQL2005 with the same setup (except the option 'allow inprocess' disabled), all the connection make to vfp is 100% successful... "

I looked and found that, as she said, in Server Objects > Linked Servers > Providers > VFPOLEDB > General tab > Provider options > Allow inprocess. Also, you can change the InProcess setting with the following code:

USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB', N'AllowInProcess', 1
GO