TSQLConnector

Databases portal

References: General info Libraries Field types Controls FAQ SQL how-to Working With TSQLQuery In-memory database applications Tutorials/practical articles: Overview 0 - Database set-up 1 - Getting started 2 - Editing 3 - Queries 4 - Data modules SQLdb Programming Reference 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:

Firebird

MSSQLServer

MySQL 4.0 - 5.7

ODBC

Oracle

Postgres

SQLite3

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

See also

• TSQLConnector doc
• Using universal database connectors