Hi Sergey,

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


>Check Re: SQL linked server with oledb Message #633186
>
>>I add the linked server like so:
>>
>>

>>Declare @server varchar(50),
>>@srvproduct varchar(50),
>>@provider varchar(50),
>>@datasrc varchar(50)
>>
>>Set @server = 'AccData'
>>Set @srvproduct = ''
>>Set @provider = 'MSDASQL'
>>Set @datasrc = 'AccData'
>>
>>EXEC master.dbo.sp_addlinkedserver
>>   @server,
>>   @srvproduct,
>>   @provider,
>>   @datasrc
>>
>>* Where AccData is a VFP ODBC datasource (System dsn), that points to a free-table directory
>>
>>

>>
>>And when I try to query I get
>>
>>....
>>Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "AccData". (Microsoft SQL Server, Error: 7303)
>>
>>For help, click...
>>
>>
>>Of course there is no help to be had from MS and googleing it has not brought me further, so an help is welcome.