Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update dbf data with data from SQL server
Message
De
19/01/2009 15:16:39
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01374980
Message ID:
01375226
Vues:
15
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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform