| Databases portal |
|
References:
Tutorials/practical articles:
Databases Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos |
TSQLConnector
is a versatile database connector component for use with any supported database. The component is found on SQLdb tab of the Component Palette.
To configure database access, most important properties are:
- ConnectorType:
| TIBConnection | Firebird |
| TMSSQLConnection | MSSQLServer |
| TMySQL40Connection | MySQL 4.0 |
| TMySQL41Connection | MySQL 4.1 |
| TMySQL50Connection | MySQL 5.0 |
| TMySQL51Connection | MySQL 5.1 |
| TMySQL55Connection | MySQL 5.5 |
| TMySQL56Connection | MySQL 5.6 |
| TMySQL57Connection | MySQL 5.7 |
| TMySQL80Connection | MySQL 8.0 |
| TODBCConnection | ODBC |
| TOracleConnection | Oracle |
| TPQConnection | Postgres |
| TSQLite3Connection | SQLite3 |
| TSybaseConnection | Sybase |
- DatabaseName
- Hostname
- Password
- Transaction
For any connector to function, it should be able to load the right drivers. *.dll style drivers are found if they are located in the same directory as the corresponding *.exe file.