Revision 1 of 2, by WikiArchive on 11-4-2026. The page as it is now.
SQLdb tab
The SQLdb tab of the Component Palette contains non-visible components for access to "large" database systems.
<figure> <img src="Component_Palette_SQLdb.png" title="Component_Palette_SQLdb.png" /> <figcaption>Component_Palette_SQLdb.png</figcaption> </figure>
<table> <thead> <tr> <th><p>Icon</p></th> <th><p>Component</p></th> <th><p>Description</p></th> </tr> </thead> <tbody> <tr> <td><figure> <img src="tsqlquery.png" title="tsqlquery.png" /> <figcaption>tsqlquery.png</figcaption> </figure></td> <td><p>TSQLQuery</p></td> <td><p>Needed to read/write data from/to a DataSet using SQL commands</p></td> </tr> <tr> <td><figure> <img src="tsqltransaction.png" title="tsqltransaction.png" /> <figcaption>tsqltransaction.png</figcaption> </figure></td> <td><p>TSQLTransaction</p></td> <td><p>Defines how changes are transferred to the databasse</p></td> </tr> <tr> <td><figure> <img src="tsqlscript.png" title="tsqlscript.png" /> <figcaption>tsqlscript.png</figcaption> </figure></td> <td><p>TSQLScript</p></td> <td><p>Scripting for execution of multiple SQL commands</p></td> </tr> <tr> <td><figure> <img src="tsqlconnector.png" title="tsqlconnector.png" /> <figcaption>tsqlconnector.png</figcaption> </figure></td> <td><p>TSQLConnector</p></td> <td><p>General connection component; the database engine is defined by property <code>ConnectorType</code></p></td> </tr> <tr> <td><figure> <img src="tmssqlconnection.png" title="tmssqlconnection.png" /> <figcaption>tmssqlconnection.png</figcaption> </figure></td> <td><p>TMSSQLConnection</p></td> <td><p>Connection component to <strong>MS SQL</strong> database engine</p></td> </tr> <tr> <td><figure> <img src="tsybaseconnection.png" title="tsybaseconnection.png" /> <figcaption>tsybaseconnection.png</figcaption> </figure></td> <td><p>TSybaseConnection</p></td> <td><p>Connection component to <strong>Sybase</strong> database engine</p></td> </tr> <tr> <td><figure> <img src="tpqconnection.png" title="tpqconnection.png" /> <figcaption>tpqconnection.png</figcaption> </figure></td> <td><p>TPQConnection</p></td> <td><p>Connection component to <strong>Postgres</strong> SQL server</p></td> </tr> <tr> <td><figure> <img src="tpqteventmonitor.png" title="tpqteventmonitor.png" /> <figcaption>tpqteventmonitor.png</figcaption> </figure></td> <td><p>TPQTEventMonitor</p></td> <td><p>Monitors events sent from the Postgres SQL database server</p></td> </tr> <tr> <td><figure> <img src="toracleconnection.png" title="toracleconnection.png" /> <figcaption>toracleconnection.png</figcaption> </figure></td> <td><p>TOracleConnection</p></td> <td><p>Connection component to <strong>Oracle</strong> database server</p></td> </tr> <tr> <td><figure> <img src="todbcconnection.png" title="todbcconnection.png" /> <figcaption>todbcconnection.png</figcaption> </figure></td> <td><p>TODBCConnection</p></td> <td><p>Connection component to an <strong>ODBC</strong> (Open Database Connectivity) data source</p></td> </tr> <tr> <td><figure> <img src="tmysql40connection.png" title="tmysql40connection.png" /> <figcaption>tmysql40connection.png</figcaption> </figure></td> <td><p>TMySQL40Connection</p></td> <td><p>Connection component to <strong>MySQL 4.0</strong></p></td> </tr> <tr> <td><figure> <img src="tmysql41connection.png" title="tmysql41connection.png" /> <figcaption>tmysql41connection.png</figcaption> </figure></td> <td><p>TMySQL41Connection</p></td> <td><p>Connection component to <strong>MySQL 4.1</strong></p></td> </tr> <tr> <td><figure> <img src="tmysql50connection.png" title="tmysql50connection.png" /> <figcaption>tmysql50connection.png</figcaption> </figure></td> <td><p>TMySQL50Connection</p></td> <td><p>Connection component to <strong>MySQL 5.0</strong></p></td> </tr> <tr> <td><figure> <img src="tmysql51connection.png" title="tmysql51connection.png" /> <figcaption>tmysql51connection.png</figcaption> </figure></td> <td><p>TMySQL51Connection</p></td> <td><p>Connection component to <strong>MySQL 5.1</strong></p></td> </tr> <tr> <td><figure> <img src="tmysql55connection.png" title="tmysql55connection.png" /> <figcaption>tmysql55connection.png</figcaption> </figure></td> <td><p>TMySQL55Connection</p></td> <td><p>Connection component to <strong>MySQL 5.5</strong></p></td> </tr> <tr> <td><figure> <img src="tmysql56connection.png" title="tmysql56connection.png" /> <figcaption>tmysql56connection.png</figcaption> </figure></td> <td><p>TMySQL56Connection</p></td> <td><p>Connection component to <strong>MySQL 5.6</strong></p></td> </tr> <tr> <td><figure> <img src="tmysql57connection.png" title="tmysql57connection.png" /> <figcaption>tmysql57connection.png</figcaption> </figure></td> <td><p>TMySQL57Connection</p></td> <td><p>Connection component to <strong>MySQL 5.7</strong></p></td> </tr> <tr> <td><figure> <img src="tsqlite3connection.png" title="tsqlite3connection.png" /> <figcaption>tsqlite3connection.png</figcaption> </figure></td> <td><p>TSQLite3Connection</p></td> <td><p>Connection component for <strong>SQLite3</strong> database files.</p></td> </tr> <tr> <td><figure> <img src="tibconnection.png" title="tibconnection.png" /> <figcaption>tibconnection.png</figcaption> </figure></td> <td><p>TIBConnection</p></td> <td><p>Connection component to <strong>InterBase/Firebird</strong></p></td> </tr> <tr> <td><figure> <img src="tfbadmin.png" title="tfbadmin.png" /> <figcaption>tfbadmin.png</figcaption> </figure></td> <td><p>TFBAdmin</p></td> <td><p>Component for Interbase/Firebird administration tasks</p></td> </tr> <tr> <td><figure> <img src="tfbeventmonitor.png" title="tfbeventmonitor.png" /> <figcaption>tfbeventmonitor.png</figcaption> </figure></td> <td><p>TFBEventMonitor</p></td> <td><p>Monitors events sent from the Interbase/Firebird server</p></td> </tr> <tr> <td><figure> <img src="tsqldblibraryloader.png" title="tsqldblibraryloader.png" /> <figcaption>tsqldblibraryloader.png</figcaption> </figure></td> <td><p>TSQLDBLibraryLoader</p></td> <td><p>Specifies the names and locations of SQLDB database libraries</p></td> </tr> </tbody> </table>
\
From the Free Pascal wiki, page "SQLdb tab", as it stood on 2021-07-22 after a change by Arent, 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.
