DRIVER={Microsoft FoxPro VFP Driver (*.dbf)};UID=;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Null=Yes;Deleted=Yes;SourceDB=D:\1C BD\1SBUKRD\

select * from FOX...[mydb]

select * from Openquery(MyFoxLynk,'select * from [1SACCS.DBF]')

Server: Msg  7399 , Level  16 , State  1 , Line  1 
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.

SELECT b.* 
FROM 
OPENROWSET( 'MSDASQL','Driver={Microsoft FoxPro VFP Driver (*.dbf)}; UID=;SourceDB=\\FINECOMP\TMP;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Null=No;Deleted=Yes','SELECT * FROM [SC869]') as b  -- где SC869.dbf
 
--;Collate=Russian

SourceDB=\\SERVER\TEMP;

SourceDB=\\FINECOMP\TMP;

Server: Msg  7399 , Level  16 , State  1 , Line  9 
OLE DB provider 'MSDASQL' reported an error.
The provider did not give any information about the error.
OLE DB error trace [Non-interface error:
  OLE DB provider MSDASQL returned an incorrect value for DBPROP_CONCATNULLBEHAVIOR which should be either DBPROPVAL_CB_NULL or DBPROPVAL_CB_NON_NULL].
OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005:
  The provider did not give any information about the error.].