Thank you. It's past 21.00 and I'm at home, so I'll try it tomorrow and let you know how I fare.
Yes I belive did install the VFP ODBC driver - otherwise I would not be able to see the tables in EM, right?
People are terribly excited about the inauguration tomorrow, so after 1600 hours local time nothing much is going to happen here.
Frankly, I didn't think it was going to happen in my lifetime, I was 12 when J.F. Kennedy was asassinated.
I guess it's fair to say "Free at last" and a belated thank you to LBJ. For all his shortcomings, he was the one who set the whole race and civil rights thing into motion.
Regards
Peter
>Below is scripted working linked server.
>Btw, did you install VFP ODBC driver on the PC running SQL Server?
>Keep in mind limitations of VFP ODBC driver
http://www.berezniker.com/content/pages/visual-foxpro/visual-foxpro-odbc-driver>
>EXEC master.dbo.sp_addlinkedserver @server = N'stxq', @provider=N'MSDASQL', @provstr=N'DRIVER={Microsoft Visual FoxPro Driver};
>Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
>SourceDB=\\fs1\Tops\daily\lccqueue\;SourceType=DBF;'
>
>
>>Sorry, 2000 fully patched.
>>
>>
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)