SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland/CodeGear/Embarcadero Delphi v.5 - 10, 2010, XE-XE10.3 and C++Builder v.5 - 2010, XE-XE10.3. It utilizes the native application programming interfaces to get to the next SQL-servers:
- IBM DB2 Universal Database
- Informix Server
- Interbase/Firebird Server
- Microsoft SQL Server
- MySQL Server
- Oracle Database Server
- PostgreSQL Server
- SQLite Database
- Sybase Adaptive Server Enterprise and Adaptive Server Everywhere
- OpenText Gupta (Centura) SQLBase
- ODBC data sources
- OLEDB data sources
SQLDirect Great Features:
- connecting to the following SQL servers using 32-bit native application programming interfaces (API): Gupta SQLBase Server 6(+), IBM DB2 Universal Database with CAE v5.2, Informix Server 7.2(+), Firebird, Interbase, MySQL 3.23(+), Oracle Server 7.2(+) with SQL*Net 2.2(+), Microsoft SQL Server, PostgreSQL 7.1(+), SQLite, Sybase Adaptive Server Enterprise and Adaptive Server Anywhere (through Open Client, which is supported by Anywhere ver.6 as native interface), ODBC and OLEDB data sources.
- no distributing, installing, and configuring the BDE or ODBC
- simultaneous access to the supported servers
- using Delphi 5, 6, 7, 9(2005), 10(2006), 2007, 2009, 2010, XE-XE10.1 or C++Builder 5, 6, 2006, 2007, 2009, 2010, XE-XE10.1 (Pro and above) to develop Client/Server applications
- query with an updatable result set
- query with macro support
- table component
- thread-safe
- BLOB-fields (including LOB and BFILE for Oracle8)
- stored procedure support (with multiple result sets for IBM DB2, Microsoft, and Sybase SQL Server)
- bi-directional and unidirectional result sets
- cached updates
- record filtering
- support of data-aware components
- InfoPower support
- using images stored by Centura/Gupta SqlWindows(or Team Developer) in their proprietary format
- interfaces (public methods and properties) of SQLDirect components are compatible with standard BDE data access components (TSession, TDatabase, TQuery ..).
The following software supports thread safety:
- Oracle SQL*Net 2.3 or above
- Centura SQLBase Ver. 7 or above
- IBM DB2 Ver. 5.2 or above
- Microsoft SQL Server Ver. 6 or above
- MySQL
- Sybase ASE and ASA through OpenClient Ver. 11.1 or above