By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,211 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,211 IT Pros & Developers. It's quick & easy.

2 databases & synchronization....

P: n/a
Hi All,

I have built 2 VB6-ACCESS XP, programs (ADODC component used). The software
works fine, updates the database and all, without any troubles. I however
now need to do something else with this. The 2 programs are identical, they
are built for 2 offices 200 miles apart, and I want the programs to
synchronize the data between the 2, automatically. The 2 computers do not
have static IP's, they however do have internet access via broadband (they
need to connect to a connecting piece of software). What I was thinking of
doing was building a piece of software to run in the background that would
detect the IP every time they connected to the net and send it to a text
file on my Linux with Apache server (not Windows, therefore no MS-SQL
updating, for anybody who was thinking in that route), the computers would
then detect the IP in the text file and synchronize.

Questions:
1. How would I build the synchronization part of the software???
2. How would I build the IP detection and uploading bit (via FTP)
software???

Any help would be appreciated.

Thanks,
Pickles.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Pickles, regarding the IP portion of the problem, check into Dynamic DNS
(DDNS). The service is free to almost free, works extremely well. It will
make the dynamic IP addresses a non problem.

"Jonathan (Pickles) Sklan-Willis" <me@picklesgeek.net> wrote in message
news:DmHwc.223$%a5.97@newsfe5-win...
Hi All,

I have built 2 VB6-ACCESS XP, programs (ADODC component used). The software works fine, updates the database and all, without any troubles. I however
now need to do something else with this. The 2 programs are identical, they are built for 2 offices 200 miles apart, and I want the programs to
synchronize the data between the 2, automatically. The 2 computers do not
have static IP's, they however do have internet access via broadband (they
need to connect to a connecting piece of software). What I was thinking of
doing was building a piece of software to run in the background that would
detect the IP every time they connected to the net and send it to a text
file on my Linux with Apache server (not Windows, therefore no MS-SQL
updating, for anybody who was thinking in that route), the computers would
then detect the IP in the text file and synchronize.

Questions:
1. How would I build the synchronization part of the software???
2. How would I build the IP detection and uploading bit (via FTP)
software???

Any help would be appreciated.

Thanks,
Pickles.

Nov 13 '05 #2

P: n/a
Randy,

Sorry it took me so long to reply. Thanks, yes that will solve that problem.

Now I need to figure out the synchronization. Anybody got any idea's?

Thanks,
Pickles.

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:fM*********************@newssvr28.news.prodig y.com...
Pickles, regarding the IP portion of the problem, check into Dynamic DNS
(DDNS). The service is free to almost free, works extremely well. It will
make the dynamic IP addresses a non problem.

"Jonathan (Pickles) Sklan-Willis" <me@picklesgeek.net> wrote in message
news:DmHwc.223$%a5.97@newsfe5-win...
Hi All,

I have built 2 VB6-ACCESS XP, programs (ADODC component used). The

software
works fine, updates the database and all, without any troubles. I however now need to do something else with this. The 2 programs are identical,

they
are built for 2 offices 200 miles apart, and I want the programs to
synchronize the data between the 2, automatically. The 2 computers do not have static IP's, they however do have internet access via broadband (they need to connect to a connecting piece of software). What I was thinking of doing was building a piece of software to run in the background that would detect the IP every time they connected to the net and send it to a text
file on my Linux with Apache server (not Windows, therefore no MS-SQL
updating, for anybody who was thinking in that route), the computers would then detect the IP in the text file and synchronize.

Questions:
1. How would I build the synchronization part of the software???
2. How would I build the IP detection and uploading bit (via FTP)
software???

Any help would be appreciated.

Thanks,
Pickles.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.