8.1 AcuODBC Server

AcuODBC Server provides you with a true two-tier environment - one in which SQL processing is performed remotely on an application server, with the results returned to the client machine. This has several advantages:

• Network traffic is reduced, since only queries are sent to the server and results returned to the client.

• Application servers are generally faster, more powerful machines, so the processing is accomplished more quickly.

• The remote server can run in the background as a service (or daemon) consuming few resources until called upon.

• This scenario facilitates centralized management of data, cutting down on duplication and ensuring that information returned to the application is always up-to-date.

The data source name (DSN) is located on the remote server.