At 11:41 AM 27-01-02 +0200, you wrote:

>Helen, I will try to do things you and the other people told, and then share
>my experience. What know I would like to know is what are your suggestions
>for accessing to FB from long distance. And I would like to give a few
>explanation for my project:
>
>This will be a sales and distrubition management program. The client program
>will be installed to salesman's laptop's who are travelling accross the
>country for taking orders. And each night they should connect to server and
>post their orders to server, update price lists and stock levels on their
>laptop (seems like a small replication). For such a project what would be
>your suggestions?

A bare-bones solution would be to use PC-Anywhere, or something equivalent (VNC is free). Have a little server app running, which they start up through PCA or VNC, that accepts a script (created by your app on the remote client machine) to feed in the updates for their day's work.

The server app would run the script, log any errors, and then create another DML script which it would send to the client. The user on the client would then run the script to bring the local database up to date. Thus the remote session is just an exchange of scripts.

Another solution would be to create a remote Telnet client and a more weighty server application. There is quite a lot of good documentation about doing this (using Delphi), at this site:

http://www.matlus.com

regards
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________