3.4. Connection parameters

The Params property of the TFDConnection component contains the database connection parameters (username, password, connection character set, etc.). If you invoke the TFDConnection property editor by double-clicking on the component, you will see that those properties have been filled automatically. The property set depends on the database type.

fbdevgd30 delphi 001

Figure 2. TFDConnection property editor

Table 1. TFDConnection component main properties
PropertyPurpose

Pooled

Whether a connection pool is used

Database

The path to the database or its alias as defined in the aliases.conf configuration file (or in databases.conf) of the Firebird server

User_Name

Firebird user name. Not used if OSAuthent is True.

Password

Firebird password. Not used if OSAuthent is True.

OSAuthent

Whether operating system authentication is used

Protocol

Connection protocol. Possible values:

  • Local — local protocol

  • NetBEUI — named pipes, WNET

  • SPX — This property is for Novell’s IPX/SPX protocol, which has never been supported in Firebird

  • TCPIP — TCP/IP

Server

Server name or its IP address. If the server is run on a non-standard port, you also need to append the port number after a slash, e.g., localhost/3051

SQLDialect

SQL Dialect. It must match that of the database

RoleName

Role name, if required

CharacterSet

Connection character set name

Additional Properties:

Connected

Used to manage the database connection or check the connection status. This property must be set to True in order for the wizards of other FireDac components to work. If your application needs to request authentication data, it is important to remember to reset this property to False before compiling your application.

LoginPrompt

Whether to request the username and password during a connection attempt

Transaction

The TFDTransaction component that will be used as default to conduct various TFDConnection transactions. If this property is not explicitly specified, TFDConnection will create its own TFDTransaction instance. Its parameters can be configured in the TxOptions property.

UpdateTransaction

The TFDTransaction component that is to be used as default for the UpdateTransaction property of TFDQuery components, unless explicitly specified for the dataset. If this property is not specified explicitly, the value from the Transaction property of the connection will be used, unless it is explicitly specified for the dataset.