TSQLConnector

│ English (en) │ français (fr) │ 日本語 (ja) │ polski (pl) │ русский (ru) │

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:

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.

See also

• TSQLConnector doc
• Using universal database connectors