exec sp_addlinkedserver @server = 'test', @srvproduct = 'VFP', @provider = 'VFPOLEDB.1', @datasrc = 'C:\Temp', @provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE' select * from test...livre Serveur : Msg 7403, Niveau 16, État 1, Ligne 1 Impossible de créer l'entrée de Registre pour le fournisseur OLE DB 'VFPOLEDB.1'.Test #2
exec sp_addlinkedserver @server = 'test1', @srvproduct = 'VFP-ODBC', @provider = 'MSDASQL', @provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=; Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No; Exclusive=No; SourceType=DBF;SourceDB=C:\Temp' select * from test1...livre Serveur : Msg 7314, Niveau 16, État 1, Ligne 1 Le fournisseur OLE DB 'test1' ne contient pas la table 'livre'. La table n'existe pas ou l'utilisateur en cours ne possède pas d'autorisations sur cette table.in the test #2, the file livre.dbf is located in the C:\TEMP directory and there is no special athorisation to access it
-- Using OLEDB provider for VFP >>>sp_addlinkedserver @server = 'test', >>> @srvproduct = 'VFP', >>> @provider = 'VFPOLEDB.1', >>> @datasrc = 'H:\Temp', >>> @provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE' >>>-- Using OLEDB provider for ODBC >>>sp_addlinkedserver @server = 'test1', >>> @srvproduct = 'VFP-ODBC', >>> @provider = 'MSDASQL', >>> @provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=; >>> Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No; >>> Exclusive=No; SourceType=DBF;SourceDB=h:\Temp' >>>Be advised that in my tests the linked server to VFP free tables that uses OLEDB provider for ODBC was considerably faster.