TSQLConnector: what changed
Revision 0 to 1. Removed lines have a minus sign; added lines have a plus sign.
Title: TSQLConnector
| Old | New | Line | |
|---|---|---|---|
| 1 | + | **TSQLConnector**  is a versatile database connector component for use with any supported database. The component is found on [[SQLdb tab]] of the [[Component Palette]]. | |
| 2 | + | ||
| 3 | + | To configure database access, most important properties are: | |
| 4 | + | ||
| 5 | + | - ConnectorType: | |
| 6 | + | ||
| 7 | + | ||
| 8 | + | ||
| 9 | + | {\| | |
| 10 | + | ||
| 11 | + | \|- \| [[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` \|} | |
| 12 | + | ||
| 13 | + | - DatabaseName | |
| 14 | + | - Hostname | |
| 15 | + | - Password | |
| 16 | + | - [[TSQLTransaction|Transaction]] | |
| 17 | + | ||
| 18 | + | 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. | |
| 19 | + | ||
| 20 | + | ## See also | |
| 21 | + | ||
| 22 | + | - [TSQLConnector doc](http://www.freepascal.org/docs-html/fcl/sqldb/tsqlconnector.html) | |
| 23 | + | - [Using universal database connectors](http://www.freepascal.org/docs-html/fcl/sqldb/universalconnectors.html) | |
| 24 | + | ||
| 25 | + | --- | |
| 26 | + | *From the Free Pascal wiki, page "TSQLConnector", as it stood on 2023-12-09 after a change by Alextpp, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's [[Licensing]] page. If you have concerns about this material, [message the admin](/wiki-contact).* |