Learn More About The FireDAC Connection Object In This RAD Studio Sample App

This sample uses the ConnectionDefName property of the TFDConnection to specify the name of the connection definition to use.

Location

You can find the TFDConnection\InfoReport sample project at:

• Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
  • Object Pascal\DataBase\FireDAC\Samples\Comp Layer\TFDConnection\InfoReport.
• GitHub Repository for Delphi: https://github.com/Embarcadero/RADStudio10.4Demos/tree/master/Object%20Pascal/Database/FireDAC/Samples/Comp%20Layer/TFDConnection/InfoReport

Description

The demo calls the GetInfoReport method to provide the report. The FireDAC environment report contains detailed information including:

• FireDAC and RAD Studio versions
• Connection definition parameters
• Database client software name and version
• Database server software name and version
• Database session information

How to Use the Sample

1. Navigate to the location given above and open:
   • Delphi: FireDACConnInfo.dproj
2. Press F9 or choose Run > Run.
3. Select one of the following options:
   • Click Get report: Populates the TMemo with detailed information about the connection status.
   • Click Get versions: Gets the DBMS client and server versions.

Implementation

• Get report button:

It calls the GetInfoReport method of the TFDConnection component to populate the TMemo with detailed information about the connection status.

[crayon-672aad34f157f423144618/]

• Get versions button:

It uses the IFDPhysConnectionMetadata interface to get the client and server versions.

See ConnectionMetaDataIntf for more information.

The link below will redirect you to the original post:

http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.InfoReport_Sample