SELECT TOP 1 * FROM OpenQuery(VFP_ADS_SERVER, 'select * from INVENTOR')

Cetin

>Cetin,
>
>Great, thanks. It's there, I can see the tables but when I
>
>

>SELECT TOP 1 * FROM [VFP_ADS_SERVER].[D:\FleetData]..[INVENTOR]
>

>
>I get
>
>

>Msg 7318, Level 16, State 1, Line 1
>OLE DB provider 'MSDASQL' returned an invalid column definition.
>

>
>I assume it's got something to do with the four part naming convention, and I've tried a few variations.
>
>So if you also happen to know the syntax for a select...
>
>
>Peter
>
>>Setting linked server is the easy part but I am not sure if that would work for updating:
>>
>>

EXEC sp_addlinkedserver
>>    @server = N'VFP_ADS_SERVER',  -- Your linked server name here
>>    @srvproduct=N'Visual FoxPro Over ADS',  -- can be anything
>>    @provider=N'MSDASQL',
>>    @provstr=N'Driver={Advantage StreamLineSQL ODBC};
>>ServerTypes=1;DefaultType=Visual FoxPro;
>>DataDirectory=C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\SAMPLES\data'

>>
>>
>>Cetin
>>
>>>Cetin,
>>>
>>>I've downloaded and installed Advantage ODBC.
>>>I've searched the online docs without success - Do you know if - and if yes - how one sets it up as a linked server?
>>>
>>>Regards
>>>
>>>Peter
>>>
>>>>OK but you don't absolutely need to do that with T_SQL or using VFPOLEDB driver.
>>>>1) Instead of T-SQL update via a linked server, use a remote view in VFP to update local data. You can take data offline and online.
>>>>2) Instead of VFPOLEDB use 'Advantage Database Server' driver. It can read write VFP tables and would behave as a layer between SQL server and VFP (I didn't test with such a configuration but in theory it should work).
>>>>http://devzone.advantagedatabase.com/dz/content.aspx?Key=20&Release=12
>>>>
>>>>Cetin
>>>>
>>>>>You would if you were in my shoes.
>>>>>
>>>>>When you have an old Clipper (sic!) application that you are -slowly- porting to SQL Server with a VFP front end, and have part of the app running in the new - and part in the old setup, with, I might add, the need to have your data consistent at one level or another, I'm quite sure that you also would see the need to update the old stuff with the new.
>>>>>
>>>>>That's just the way the cookie crumbles.
>>>>>
>>>>>:-)