BDESQL Links, IBExpress, dbExpress, and dbGo (Two-Tier)

   

---

BDE/SQL Links, IBExpress, dbExpress, and dbGo (Two- Tier )

The BDE deals with client-server relational databases through an additional layer called SQL Links . You can think of it as a translator between the BDE API and the database engine's API (the SQL Links modules are often called drivers). The Enterprise version includes SQL Links for Oracle, SQL Server, DB2, and InterBase. The Professional version includes only SQL Links for InterBase.

This is also called a two-tier architecture, and it is one of the most popular for traditional database applications. It provides the most power, flexibility, and integration for the price without adding the extra complexities of a multitier architecture.

Interbase is usually a client-server database, so the IBExpress components can be used as part of a client-server installation.

This is also true for the dbExpress components, whose drivers provide access to Interbase, DB2, Oracle, MySQL, and Informix.

ADO components in dbGo can also use client-server providers or ODBC drivers for client-server databases.

---

Top