Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two places and one database.
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00687322
Message ID:
00687421
Views:
9
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform