Unsupported database version

Oct 13, 2025 by pinkandtrash.com 6 views

Delphi Firedac Backup Error: [FireDAC][Phys][FB] Feature is Not Supported

When working with Delphi and FireDAC, database management is a crucial aspect of any application. FireDAC provides a robust set of features for interacting with various databases, including MySQL, Oracle, and Firebird. However, when attempting to perform a backup or restore operation, you may encounter errors that can be frustrating to resolve. In this article, we will explore the common issue of the [FireDAC][Phys][FB] feature is not supported error when using the TFDFBNBackup component to backup a Firebird database.

The [FireDAC][Phys][FB] feature is not supported error typically occurs when FireDAC encounters a feature or functionality that is not supported by the Firebird database. This can be due to various reasons, such as:

Unsupported database version: FireDAC may not support the version of Firebird you are using.
Unsupported database features: Firebird may not support certain features, such as encryption or compression, that are enabled in FireDAC.
Configuration issues: FireDAC configuration settings may be incorrect or incomplete, leading to errors.

To troubleshoot the [FireDAC][Phys][FB] feature is not supported error, follow these steps:

1. Check Firebird Database Version

Ensure that your Firebird database version is compatible with FireDAC. You can check the Firebird version by connecting to the database using the Firebird Administrator tool or by querying the RDB$DATABASE table.

2. Review FireDAC Configuration

Verify that your FireDAC configuration settings are correct and complete. Check the FDConnection component's Params property to ensure that all required settings are specified.

3. Disable Unsupported Features

Disable any unsupported features in FireDAC, such as encryption or compression, to see if the error persists.

4. Update FireDAC to Latest Version

Ensure that you are using the latest version of FireDAC. Updates often include bug fixes and support for new features.

5. Consult Firebird Documentation

Refer to the Firebird documentation to understand the features and limitations of your Firebird database version.

Here is an example code snippet that demonstrates how to use the TFDFBNBackup component to backup a Firebird database:

uses
  FireDAC.Stan.Intf,
  FireDAC.Phys,
  FireDAC.Phys.FB,
  FireDAC.Comp.Client;

type
  TForm1 = class(TForm)
    FDConnection1: TFDConnection;
    FDPhysFBNBackup1: TFDPhysFBNBackup;
    procedure FormCreate(Sender: TObject);
  end;

procedure TForm1.FormCreate(Sender: TObject);
var
  BackupFile: string;
begin
  // Set up FireDAC connection
  FDConnection1.Params.Clear;
  FDConnection1.Params.Add('Database=C:\Path\To\Database.fdb');
  FDConnection1.Params.Add('User_Name=sysdba');
  FDConnection1.Params.Add('Password=masterkey');
  FDConnection1.Connected := True;

  // Create backup file
  BackupFile := 'C:\Path\To\Backup.fbk';

  // Create backup component
  FDPhysFBNBackup1 := TFDPhysFBNBackup.Create(Self);
  FDPhysFBNBackup1.Connection := FDConnection1;
  FDPhysFBNBackup1.FileName := BackupFile;
  FDPhysFBNBackup1.Execute;
end;

The [FireDAC][Phys][FB] feature is not supported error can be frustrating to resolve, but by following the troubleshooting steps outlined in this article, you should be able to identify and fix the issue. Remember to check Firebird database version, review FireDAC configuration, disable unsupported features, update FireDAC to latest version, and consult Firebird documentation. With these steps, you should be able to successfully backup and restore your Firebird database using FireDAC.
Delphi Firedac Backup Error: [FireDAC][Phys][FB] Feature is Not Supported - Q&A

In our previous article, we explored the common issue of the [FireDAC][Phys][FB] feature is not supported error when using the TFDFBNBackup component to backup a Firebird database. In this article, we will provide a Q&A section to help you better understand the issue and its solutions.

Q: What is the [FireDAC][Phys][FB] feature is not supported error?

A: The [FireDAC][Phys][FB] feature is not supported error is a common issue that occurs when FireDAC encounters a feature or functionality that is not supported by the Firebird database.

Q: Why do I get this error when trying to backup my Firebird database?

A: You may get this error due to various reasons, such as:

Unsupported database version: FireDAC may not support the version of Firebird you are using.
Unsupported database features: Firebird may not support certain features, such as encryption or compression, that are enabled in FireDAC.
Configuration issues: FireDAC configuration settings may be incorrect or incomplete, leading to errors.

Q: How can I troubleshoot the [FireDAC][Phys][FB] feature is not supported error?

A: To troubleshoot the error, follow these steps:

Check Firebird Database Version: Ensure that your Firebird database version is compatible with FireDAC.
Review FireDAC Configuration: Verify that your FireDAC configuration settings are correct and complete.
Disable Unsupported Features: Disable any unsupported features in FireDAC, such as encryption or compression, to see if the error persists.
Update FireDAC to Latest Version: Ensure that you are using the latest version of FireDAC.
Consult Firebird Documentation: Refer to the Firebird documentation to understand the features and limitations of your Firebird database version.

Q: What are some common causes of the [FireDAC][Phys][FB] feature is not supported error?

A: Some common causes of the error include:

Incorrect FireDAC configuration settings: Ensure that all required settings are specified in the FDConnection component's Params property.
Unsupported database features: Disable any unsupported features in FireDAC, such as encryption or compression.
Firebird database version issues: Ensure that your Firebird database version is compatible with FireDAC.

Q: How can I prevent the [FireDAC][Phys][FB] feature is not supported error from occurring in the future?

A: To prevent the error from occurring in the future, follow these best practices:

Regularly update FireDAC to the latest version: Ensure that you are using the latest version of FireDAC.
Verify FireDAC configuration settings: Regularly review and verify FireDAC configuration settings to ensure that all required settings are specified.
Consult Firebird documentation: Refer to the Firebird documentation to understand the features and limitations of your Firebird database version.

The [FireDAC][Phys][FB] feature is not supported error can be frustrating to resolve, but by following the troubleshooting steps and best practices outlined in this article, you should be able to identify and fix the issue. Remember to check Firebird database version, review FireDAC configuration, disable unsupported features, update FireDAC to latest version, and consult Firebird documentation. With these steps, you should be able to successfully backup and restore your Firebird database using FireDAC.