Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC Server - Help
Message
De
25/10/1998 19:42:44
Steve Brownlow
Computer Fiscal Services
Sydney, Australie
 
 
À
23/10/1998 10:38:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00149748
Message ID:
00150360
Vues:
25
>Any data format that has an ODBC driver can become an ODBC server. This includes VFP, SQL Server, Access any DBMS worth its salt, and even other backends like Excel. ODBC is a mechanism that provides a common interface for all of these 'backends'. If you create an ODBC Data source from your database (or whatever) you can then access that data source from any application that is capable of opening ODBC datasources.
>So I have a database that was built in MS Access. I go to Start-> Settings -> Control Panel -> ODBC, and click add. I select MS Access Driver, and then give my data source a name, and locate the .mdb file. Done. I can now open VFP, open my VFP database, right click in the designer and choose connections. I click on Add, and select my new datasource from the list. I now have a connection to an Access database from VFP. With this, I can create remote views to access that data. This is the 2 minute client server tutorial. Any questions?

Eric,

Trying to clearly understand how to do this...

With your ODBC example above, if the Access data is on one server PC and a VFP application is on a client PC, then it seems that these need to exist:
- ODBC driver on server
- VFP database on client
- VFP Remote view defined on client
- VFP application on client

Is that right?
Are more components needed?
How does the client SEE the server datasource?
Could we use native VFP as the database on the server?

We're trying to minimise data transfer between the server and client.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform