Hi Guys,

I have to prepare a program that will syncronise data between 3 different
physical locations of data entry. This program will be used for just 2 days
and the data will be tiny, the client can afford to be online for the two
days constanly. What approach would you suggets best for me.

Regards
Allan

Buy IBReplicator (I don't know if still separated product).

--
Sergio Samayoa
Lgica Software
http://www.geocities.com/logicasw/

        It's included with the certified edition but also available separately
for non-certified editions or pre-v6.

        -Craig

--
Craig Stuntz (TeamB)       Senior Developer, Vertex Systems Corp.
Delphi/InterBase weblog:   http://delphi.weblogs.com
Use Borland servers; posts via others are not seen by TeamB.
For more info, see http://www.borland.com/newsgroups/genl_faqs.html

Hi Guys,

Thanks for the quick reply, but IBReplicator solution will not work.
The system is thus :
Tickets will be given free to persons holding a particular Credit Card.
There are about 1000 tickets to be given. There will be 3 centres in the
vicinity of 6 Kms doing this task. What is important is that 2 tickets
should not be issued on one card. If my software is not syncronised between
the 3 centres  then there will be a problem,
because a person could shuttle to the next centre within minutes.

Regards
Allan.

Why about database centralization ? All centers use just one database
located at any of them.

--
Sergio Samayoa
Lgica Software
http://www.geocities.com/logicasw/

Database centralization sounds perfect. Could you give me a lead of how I'am
to connect, so that I can then read further on that topic.
for instance should I connect via internet or can I dial the computer
directly ?
In case I dial directly what component should I use ? Is there any example I
can refer at, say , code central.
I have Delphi 5 Enterprise version.

Thanks !!

Have a look at ASTA (www.astatech.com). I am using ASTA components in
developing an industry specific application which allows users to access
a central database using the internet.

--
Cheers,

Phillip Flores
+-----------------------------------------------+
| "Where did your time go today? Get VeriTime!" |
| http://www.pcfworks.com"                      |
| "The Delphi Catalog"                          |
| http://www.delphicatalog.com                  |
+-----------------------------------------------+

1. You can expose your database to the internet. Get an Internet IP address
for your database server, connect it to the internet and open port 3050 on
your firewall. Remember to change the SYSDBA password before exposiong your
database to the Internet. After that connect your client computer machines
to the internet using whatever method you want, then connect to your IB
server as you already known (servername:databaselocation or
serverip:databaselocation).

2. You can set up a RAS server on your main site and connect from your
remote sites via telephone.

3. Set up a VPN over the Internet.

...

The most important thing is connect your computers (server and clients) to
the same IP network. Afer that you can use any component (preferable IBX's
TIBDataSet) to access your database from your Delphi applications. When you
design your application take care of the band width: few open cursors, small
result sets, minimal requiered field sets, etc.