Difference between revisions of "TSQLConnector"
From Free Pascal wiki
Jump to navigationJump to searchm |
|||
Line 4: | Line 4: | ||
To configure database access, most important properties are: | To configure database access, most important properties are: | ||
− | * ConnectorType: | + | * ConnectorType: |
− | :: | + | ::{| |
− | + | |- | |
− | + | | [[TIBConnection]] || <tt>Firebird</tt> | |
− | + | |- | |
− | + | | [[TMSSQLConnection]] || <tt>MSSQLServer</tt> | |
− | + | |- | |
− | + | | [[TMySQL40Connection]] || <tt>MySQL 4.0</tt> | |
− | + | |- | |
+ | | [[TMySQL57Connection]] || <tt>MySQL 5.7</tt> | ||
+ | |- | ||
+ | | [[TODBCConnection]] || <tt>ODBC</tt> | ||
+ | |- | ||
+ | | [[TOracleConnection]] || <tt>Oracle</tt> | ||
+ | |- | ||
+ | | [[TPQConnection]] || <tt>Postgres</tt> | ||
+ | |- | ||
+ | | [[TSQLite3Connection]] || <tt>SQLite3</tt> | ||
+ | |- | ||
+ | | [[TSybaseConnection]] || <tt>Sybase</tt> | ||
+ | |} | ||
* DatabaseName | * DatabaseName | ||
* Hostname | * Hostname |
Revision as of 16:54, 22 July 2021
│
English (en) │
français (fr) │
日本語 (ja) │
polski (pl) │
русский (ru) │
References:
Tutorials/practical articles:
Databases |
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 TMySQL57Connection MySQL 5.7 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
See also