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