Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
C++DatabaseDelphiIDERAD Studio

Addressing the Problem of the Missing dbxConnections.ini File

There is an issue with RAD Studio 10.4.x related with dbExpress configuration, that you can work around by creating a new configuration file.

When you install RAD Studio 10.4 (or 10.4.1) or Delphi or C++Builder, there is an error in the installation script that causes a configuration file to be missing. The lack of this file, that the IDE expects, causes a few errors reported for example as:

RSP-29199: Error on ConnectionName selection in TSQLConnection

RSP-30831: Error in dbxconnections

In practice, if you use the dbExpress section of the Database Explorer to create a new connection, you end up with an access violation in the IDE:

dbxini_01-7719813

dbxini_02-2280087

Instead, if you try to select a connecting in the SQLConnection component, you’ll see the proper error message:

dbxini_03-3606157

The issue is caused by the fact in the the installer leaves separate, partial configuration files (dbxconnections.win.x files) in the C:\Users\Public\Documents\Embarcadero\Studio\dbExpress\21.0 folder rather than merging them in a single dbxconnections.ini file. The ideal solution is to merge them manually in a new dbxconnections.ini file, but you can also just create a new empty dbxconnections.ini file or use one from a previous version of RAD Studio.

As soon as you add that file (and restart RAD Studio), the IDE will behave correctly and your new connections will be added to the ini file.

dbxini_04-6425204

Notice also that the dbExpress library (or DBX) is formally deprecated and not maintained any more, which is why we missed this configuration issue. The recommendation is to migrate from it to FireDAC (see this RAD Studio docWiki page) or some other database access library.

See What's New in 12.2 Athens See What's New in 12.2 Athens Dev Days of Summer 2-24

Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

About author

Marco is one of the RAD Studio Product Managers, focused on Delphi. He's the best selling author of over 20 books on Delphi.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES