FireDac Exception when running the articles_crud_server and articles_crud_vcl_client

[Basti-Fantasti]

Hi,

I'm playing around with the provided samples in the MVCFramework 3.3.0 samples folder. Both the server as well as the vcl client are compiling fine.

I start the server and then the vcl client When I click on connect in the vcl client I get the following error:

What needs to be configured in the missing FDConnectionDefs.ini

Can you please supply the information along with the sample projects?

• Which database file
• which driver (Firebird? 2.5? 3.0? 4.0?) Maybe the section which needs to be added to the INI file or maybe a direct call to the database without an alias (not sure if this is possible with the Firedac driver)

Here's the log from the server:

2023-12-14 16:15:27:784  [TID 35488   ][INFO      ] Default Logger initialized [dmvcframework]
2023-12-14 16:15:27:784  [TID 35488   ][INFO      ] ENTER: Config default values [dmvcframework]
2023-12-14 16:15:27:784  [TID 35488   ][INFO      ] EXIT: Config default values [dmvcframework]
2023-12-14 16:15:27:784  [TID 35488   ][INFO      ] >> Custom configuration method [dmvcframework]
2023-12-14 16:15:27:784  [TID 35488   ][INFO      ] << Custom configuration method [dmvcframework]
2023-12-14 16:15:27:784  [TID 35488   ][INFO      ] ENTER: LoadSystemControllers [dmvcframework]
2023-12-14 16:15:27:784  [TID 35488   ][INFO      ] EXIT: LoadSystemControllers [dmvcframework]
2023-12-14 16:15:27:788  [TID 35488   ][ERROR     ] [EFDException] [FireDAC][Stan][Def]-254. Definition [articles_crud_db] in [C:\Users\Public\Documents\Embarcadero\Studio\FireDAC\FDConnectionDefs.ini] nicht gefunden [PathInfo "GET /articles"] (Custom message: "Global Action Exception Handler") [dmvcframework]

EDIT:

While debugging through the server code, I see that the firebird 4.0 database file is found, but directly after leaving the ConnectionBeforeConnect procedure the exception is raised

EDIT 2:

After some more research (and never before using the FireDac Stuff) I found the Firedac Explorer. How can I select the appropriate Firebird 4.0 driver? I can only select Firebird (FB) Do I need to install the Firebird Server 4.0 in advance?

[Basti-Fantasti]

Now I finally managed to get the demo up and running. It was quite some work to do:

• Install Firebird 4.0 Server (not easy when version 2.5 is already installed)
• collect all files needed as drivers for the firebird 4.0 server
• setup sysdba user (firebird 4.0 has no default sysdba account anymore)
• modified FDDrivers.ini to find the correct driver in the specified location

Now I'm just thinking howto deploy a project like this using the Firedac implementation for a firebird database. What files need to be added to the distribution so that the app finds the corresponding drivers

[danieleteti]

Hi, to deploy a FireDAC based DMVCFramework you jave just to follow the normal procedure for any FireDAC application.

https://docwiki.embarcadero.com/RADStudio/en/Deploying_on_Windows_(FireDAC)