Prev: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security e
Next: Default Trace Logs - increase size
From: tlyczko on 21 Jul 2008 09:38
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
directory.

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
server.

Thank you, Tom



From: tlyczko on 22 Jul 2008 12:36
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
tables.

Thank you, Tom
 | 
Pages: 1
Prev: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security e
Next: Default Trace Logs - increase size