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.

• 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