Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Pass Through
Message
De
17/11/1999 13:48:50
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Pass Through
Divers
Thread ID:
00292048
Message ID:
00292048
Vues:
45
Where does the SQL Statement Actually execute?

I make sure System_A is not running any VFP serivces.
I share a folder on System_A
I set up an ODBC connection on System_B pointing to a VFP dtabase container on System_A's folder.
I use the SQLConnect Command on System_B to connect to the data source.
I use the SQLExec command to pass a SQL Select to System_A.
Finally I do get results as expected.

Now which system did the data processing of the SQL statement. System_A (the data store) or System_B (the data requestor). Remember this is a VFP database and no VFP Service is running.
Terry Rooks
Software Systems Architect
Microsoft Certified Solution Developer.Net

If at first you don't succeed, then skydiving definitely isn't for you.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform