Yes, afaik - I can see it in Mgmt Studio under Linked Servers -> Providers -> VFPOLEDB. It's SQL 2005 btw.

Also, when I did not have it on the server I got a different error.

ODBC example does not work either - same error.


>Did you instll VFP OLE DB provider on the server?
>
>
>>
>>Thank's! And btw, Allow inprocess is checked for the VFPOLEDB provider.
>>
>>I copied your script - (changed H:\Temp to the free table dir ??) - and added the server, refreshed, but when I try to click on Catalog - Default - Tables I get:
>>
>>TITLE: Microsoft SQL Server Management Studio
>>------------------------------
>>
>>Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
>>
>>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
>>
>>------------------------------
>>ADDITIONAL INFORMATION:
>>
>>An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
>>
>>------------------------------
>>
>>Cannot create an instance of OLE DB provider "VFPOLEDB.1" for linked server "test". (Microsoft SQL Server, Error: 7302)
>>
>>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7302&LinkId=20476
>>
>>------------------------------
>>BUTTONS:
>>
>>OK
>>------------------------------
>>
>>