Where does Delphi Store the Data Explorer Connection Info?

Question

I just created a brand new FireDAC InterBase connection called "MyNewIBConnection" in Delphi 10 Seattle. The connection works great.

Where does Delphi store this connection info?

Answer 1

It's easy after you know where to look:
1. Click Tools > FireDAC Explorer
2. Click Connection definitions

The file location is displayed in the Workstation configuration panel.

Answer 2

It's in the dbxconnections.ini file. I found it in this location (it may differ for your Delphi version):

C:\Users\PUBLIC\Documents\RAD Studio\dbExpress\dbxconnections.ini

How did I find it? After searching BLACKFISHSQLEMPLOYEECONNECTION term in registry (it was the rarest name in my Data Explorer, was not found in registry), I ran Process Monitor with Rename Connection dialog opened and filtered there non-registry operations of the IDE process.

Answer 3

The location of the connection file (FDConnectionDefs.ini) ist stored in this registry key:

HKEY_CURRENT_USER\Software\Embarcadero\FireDAC\ConnectionDefFile

Normally it uses the environment variable "FDHOME" inside this registry key to define the actual directory where the file is stored.