bjonessb wrote:

>The best approach would be to use a 3-tier design. You need
>middleware. Examples are KbmMW, Remobjects, and Asta.
>
>It works like this. The Middleware runs on the same network (or
>even the same server) as the Firebird database server. The
>middleware will retrieve datasets from the Firebird server on behalf
>of the client. It will then stream the dataset (and only the
>dataset, without all the overhead) to the client. It can even
>compress the dataset before streaming to the client. This solution
>even works with a dial-up connection. It is even a little faster
>than a web application, because all of the html doesn't have to be
>sent over the wire... just the data is sent.
>
>Asta is probably the easiest one to get started. They've built
>several generic application servers for you.
>
>Bill
>
>

Another solution would be to use a replicator. The advantage is that you
don't have to modify your application in any way. You just make it work
offline, and have the replicator kick in every minute or so to
synchronize. It can be a bit difficult to set up, but the result is
definitely satisfactory, as per my own experience.

HTH,
Jonathan Neve.