General information
Category:
Internet applications
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only