473,465 Members | 1,931 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

2 databases & synchronization....

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
2 1703
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Lobang Trader | last post by:
Hi all, I am trying to create a username and a password class. I would like to know what are the RECOMMENDED minimum and maximum length for both fields? These fields will be something like...
3
by: 21novembre | last post by:
Hi all, I made a question several days before to describe my strange trouble of mysqldump. But I still can't figour it out. Well, I just want to ask another question whether I could just backup...
1
by: chandrub78 | last post by:
Hello Everyone We have a third party tool which maintains its own custom database,DB1 on SQL Server 2000 on Server A (Windows 2000). We built an inhouse application which maintains a transactional...
7
by: Joe Wasik | last post by:
Hello, Currently I used Biomobility's DataOnTheRun for the Pocket PC. It's a little slow, but it does exactly what I need -- and it does it well. Unfortunately, now I need to have the same...
8
by: Rick | last post by:
I'm running an Access2000 front end mde linked to an Access2000 back end mdb. I need to set up replication and synchronization of only the data tables between the master db on the pc and replicas...
8
by: Z D | last post by:
Hello, I'm having a strange problem that is probably due to my lack of understanding of how threading & COM Interop works in a WinForms.NET application. Here's the situation: I have a 3rd...
4
by: scott | last post by:
hi all, Thx to any one that can offer me help, it will be much appreciated. iv got a multithreaded program and need to use thread synchronization. The synchronization does not have to...
0
by: shubh | last post by:
Hi I have two similar MS-SQL databases running at two different locations. How do I synchronize the data in those via a dial up internet connection? I would appreciate your help/tips on this.
1
Nert
by: Nert | last post by:
Hello there, I guess i didn't made the title of my question pretty clear, so here's the detail. In our company, we have this system we called MRP (Material Requirements Planning) System, it was...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.