Database Components

A 3-tier multi-user application using a shared database needs to handle concurrency. It happens both with desktop and web applications. In many ways, this also happens to a client/server desktop application accessing a database from several threads.

Some databases accept a single connection, while others have different limits. As mentioned before, connection pooling is a helpful feature typically available for high-end database engines (like Microsoft SQL Server and Oracle) using the right data access technology (like ADO and FireDAC).

In this section, we will describe how to configure several database components for selected database engines.