Difference between revisions of "TSQLConnector"

From Lazarus wiki
Jump to navigationJump to search
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{TSQLConnector}}
 
{{Infobox databases}}
 
{{Infobox databases}}
 
'''TSQLConnector''' [[image:tsqlconnector.png]] is a versatile database connector component for use with any supported database. The component is found on [[SQLdb tab]] of the [[Component Palette]].
 
'''TSQLConnector''' [[image:tsqlconnector.png]] 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:
 
To configure database access, most important properties are:
−
* ConnectorType:
+
* ConnectorType:
−
::<tt>[[TIBConnection|Firebird]]</tt>   
+
::{|
−
::<tt>[[TMSSQLConnection|MSSQLServer]]</tt>
+
|-
−
::<tt>[[TMySQL40Connection|MySQL 4.0]] - [[TMySQL56Connection|5.7]]</tt>
+
| [[TIBConnection]] || <tt>Firebird</tt> 
−
::<tt>[[TODBCConnection|ODBC]]</tt>   
+
|-
−
::<tt>[[TOracleConnection|Oracle]]</tt>  
+
| [[TMSSQLConnection]] || <tt>MSSQLServer</tt>   
−
::<tt>[[TPQConnection|Postgres]]</tt>   
+
|-
−
::<tt>[[TSQLite3Connection|SQLite3]]</tt>  
+
| [[TMySQL40Connection]] || <tt>MySQL 4.0</tt>
−
::<tt>[[TSybaseConnection|Sybase]]</tt>  
+
|-
 +
| [[TMySQL41Connection]] || <tt>MySQL 4.1</tt>
 +
|-
 +
| [[TMySQL50Connection]] || <tt>MySQL 5.0</tt>  
 +
|-
 +
| [[TMySQL51Connection]] || <tt>MySQL 5.1</tt>
 +
|-
 +
| [[TMySQL55Connection]] || <tt>MySQL 5.5</tt>
 +
|-
 +
| [[TMySQL56Connection]] || <tt>MySQL 5.6</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
Line 25: Line 48:
  
 
{{LCL Components}}
 
{{LCL Components}}
−
[[Category:Databases]]
 

Revision as of 20:33, 22 July 2021

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

Databases portal

References:

Tutorials/practical articles:

Databases

Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos

TSQLConnector tsqlconnector.png 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
TODBCConnection ODBC
TOracleConnection Oracle
TPQConnection Postgres
TSQLite3Connection SQLite3
TSybaseConnection Sybase

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


LCL Components
Component Tab Components
Standard TMainMenu • TPopupMenu • TButton • TLabel • TEdit • TMemo • TToggleBox • TCheckBox • TRadioButton • TListBox • TComboBox • TScrollBar • TGroupBox • TRadioGroup • TCheckGroup • TPanel • TFrame • TActionList
Additional TBitBtn • TSpeedButton • TStaticText • TImage • TShape • TBevel • TPaintBox • TNotebook • TLabeledEdit • TSplitter • TTrayIcon • TControlBar • TFlowPanel • TMaskEdit • TCheckListBox • TScrollBox • TApplicationProperties • TStringGrid • TDrawGrid • TPairSplitter • TColorBox • TColorListBox • TValueListEditor
Common Controls TTrackBar • TProgressBar • TTreeView • TListView • TStatusBar • TToolBar • TCoolBar • TUpDown • TPageControl • TTabControl • THeaderControl • TImageList • TPopupNotifier • TDateTimePicker
Dialogs TOpenDialog • TSaveDialog • TSelectDirectoryDialog • TColorDialog • TFontDialog • TFindDialog • TReplaceDialog • TTaskDialog • TOpenPictureDialog • TSavePictureDialog • TCalendarDialog • TCalculatorDialog • TPrinterSetupDialog • TPrintDialog • TPageSetupDialog
Data Controls TDBNavigator • TDBText • TDBEdit • TDBMemo • TDBImage • TDBListBox • TDBLookupListBox • TDBComboBox • TDBLookupComboBox • TDBCheckBox • TDBRadioGroup • TDBCalendar • TDBGroupBox • TDBGrid • TDBDateTimePicker
Data Access TDataSource • TCSVDataSet • TSdfDataSet • TBufDataset • TFixedFormatDataSet • TDbf • TMemDataset
System TTimer • TIdleTimer • TLazComponentQueue • THTMLHelpDatabase • THTMLBrowserHelpViewer • TAsyncProcess • TProcessUTF8 • TProcess • TSimpleIPCClient • TSimpleIPCServer • TXMLConfig • TEventLog • TServiceManager • TCHMHelpDatabase • TLHelpConnector
Misc TColorButton • TSpinEdit • TFloatSpinEdit • TArrow • TCalendar • TEditButton • TFileNameEdit • TDirectoryEdit • TDateEdit • TTimeEdit • TCalcEdit • TFileListBox • TFilterComboBox • TComboBoxEx • TCheckComboBox • TButtonPanel • TShellTreeView • TShellListView • TXMLPropStorage • TINIPropStorage • TJSONPropStorage • TIDEDialogLayoutStorage • TMRUManager • TStrHolder
LazControls TCheckBoxThemed • TDividerBevel • TExtendedNotebook • TListFilterEdit • TListViewFilterEdit • TLvlGraphControl • TShortPathEdit • TSpinEditEx • TFloatSpinEditEx • TTreeFilterEdit • TExtendedTabControl •
RTTI TTIEdit • TTIComboBox • TTIButton • TTICheckBox • TTILabel • TTIGroupBox • TTIRadioGroup • TTICheckGroup • TTICheckListBox • TTIListBox • TTIMemo • TTICalendar • TTIImage • TTIFloatSpinEdit • TTISpinEdit • TTITrackBar • TTIProgressBar • TTIMaskEdit • TTIColorButton • TMultiPropertyLink • TTIPropertyGrid • TTIGrid
SQLdb TSQLQuery • TSQLTransaction • TSQLScript • TSQLConnector • TMSSQLConnection • TSybaseConnection • TPQConnection • TPQTEventMonitor • TOracleConnection • TODBCConnection • TMySQL40Connection • TMySQL41Connection • TMySQL50Connection • TMySQL51Connection • TMySQL55Connection • TMySQL56Connection • TMySQL57Connection • TSQLite3Connection • TIBConnection • TFBAdmin • TFBEventMonitor • TSQLDBLibraryLoader
Pascal Script TPSScript • TPSScriptDebugger • TPSDllPlugin • TPSImport_Classes • TPSImport_DateUtils • TPSImport_ComObj • TPSImport_DB • TPSImport_Forms • TPSImport_Controls • TPSImport_StdCtrls • TPSCustomPlugin
SynEdit TSynEdit • TSynCompletion • TSynAutoComplete • TSynMacroRecorder • TSynExporterHTML • TSynPluginSyncroEdit • TSynPasSyn • TSynFreePascalSyn • TSynCppSyn • TSynJavaSyn • TSynPerlSyn • TSynHTMLSyn • TSynXMLSyn • TSynLFMSyn • TSynDiffSyn • TSynUNIXShellScriptSyn • TSynCssSyn • TSynPHPSyn • TSynTeXSyn • TSynSQLSyn • TSynPythonSyn • TSynVBSyn • TSynAnySyn • TSynMultiSyn • TSynBatSyn • TSynIniSyn • TSynPoSyn
Chart TChart • TListChartSource • TRandomChartSource • TUserDefinedChartSource • TCalculatedChartSource • TDbChartSource • TChartToolset • TChartAxisTransformations • TChartStyles • TChartLegendPanel • TChartNavScrollBar • TChartNavPanel • TIntervalChartSource • TDateTimeIntervalChartSource • TChartListBox • TChartExtentLink • TChartImageList
IPro TIpFileDataProvider • TIpHtmlDataProvider • TIpHttpDataProvider • TIpHtmlPanel
Virtual Controls TVirtualDrawTree • TVirtualStringTree • TVTHeaderPopupMenu


Retrieved from "http://wiki.freepascal.org/index.php?title=TSQLConnector&oldid=145964"