Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two places and one database.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00687322
Message ID:
00687421
Vues:
8
Hi,

>>
I have a client who ask me about the possibility link two offices in just one database.
Nowadays, I send a file every night with all changes that happened during the current day. I think some ways to do it:

a) Install one database like SQL Server or Postgree and acess it using Pass-Through (connecting via IP)
b) Web Services / XML
c) COM+ / DBC

Important: There are few transactions per day. Its just for internal use, not for sales via internet and so on...

What should I do?
<<

You don't mention the size of the database involved or the bandwidth of the connection you will be using. If the tables are relatively small and the bandwidth reasonably high then you could try accessing the tables just as if they were on the local network. Eg:

USE \\213.253.111.222\C\XX.DBF &&etc.

etc. It's only likely to give acceptable performance on smallish tables and you need to consider security but it's simple enough to be worth a try.

Regards,
Viv
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform