>>See Re: SQL linked server with oledb Message #633186.
>
>Well, I tried this
>

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

>
>and it seems to be ok (sp_helpserver return 'test1'), but on SELECT statement I receive an error:
>
>
>OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBSchemaRowset::GetRowset returned 0x80010105: Provider caused a server fault in an external process.].
>.Net SqlClient Data Provider: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'MSDASQL' reported an error. Provider caused a server fault in an external process.
>
>
>Seems I don't have a kind of MSDASQL driver or library?

Are you sure that test1 is a linked server to VFP tables? It doesn't look this way based on the error message. Do you have VFP ODBC driver on the PC with SQL Server?