Hi Sergey,

This is all quite frustrating.

I've set up (yet another) linked server.

/****** Object:  LinkedServer [DBF]    Script Date: 01/19/2009 16:46:26 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'DBF', @srvproduct=N'VFP', @provider=N'MSDASQL', @datasrc=N'DbfTest'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DBF',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'use remote collation', @optvalue=N'true'

That's the server, but when I query it or click Catalogs -> Refresh it says:

OLE DB provider 'UNKNOWN' reported an error. One or more arguments were reported invalid by the provider. (Microsoft SQL Server, Error: 7399)

What am I doing wrong?

BR

Peter








>>Well, maybe not you exactly - please forgive me, if I misquoted you.
>>You basically said it works despite the error, but to use CLR procedures.
>>Like I said, I'm not familiar with CLR procs and would prefer to do it in a plain sp with T-SQL.
>>
>>And Sergey wrote
>>"It may not be possible because VFP OLE DB provider supports only read (query data) access when used in a linked server/OPENROWSET"
>>
>>I guess that's were "stubborn" comes into the picture :-))
>
>I answered your specific question. Nowhere did I say that it's not possible in general.
>A Linked server with VFP ODBC driver can do that. A DTS could be an option as well.