From: tlyczko on
I am using SSMS to create a linked server to a VFP free tables
directory, and I keep getting this error after clicking 'Tables' in
the SSMS GUIr:

The OLE DB provider "VFPOLEDB" for linked server "T1" reported an
error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE
DB provider "VFPOLEDB" for linked server "T1". (Microsoft SQL Server,
Error: 7399)

The login being used on the SQL server is an administrator account,
and both this account and the SQL Server have full rights to the data

What other permissions are needed??

I am using the following:

Provider: MS OLE DB for Visual FoxPro

Product name: VFP

Data source: -- where the data files are -- testing the connection
always works

Provider string: VFPOLEDB.1?? VFPOLEDB.2?? The error appears
regardless what is typed here.

No security context, no changes to the other options.

I already set up a proper temp directory on the server.

I've found plenty of scripts comments, but not enough explanation or
context to understand what the authors mean.

BTW these are Abra Suite FoxPro tables -- rather old FoxPro files.

The most current VFP OLE DB provider -- 1.2 -- is installed to the SQL

Thank you, Tom

From: tlyczko on
I became lucky and found a solution.

A post in another Internet forum gave me the idea to check off and
enable 'Allow inprocess' for the VFP OLE DB provider.

This made all the errors etc. go away and provided access to the VFP

Thank you, Tom