How to deploy a FireDAC app with DataAbstract

Data Abstract
,
1

Hi guys,

I’m using DA latest non-beta version with Seattle Update 1. I want to use FireDAC with MSSQL. Currently via Schema modeler there is no problem defining the connection and loading the required data. Now while deploying to production our client module it returns this error:

An exception was raised on the server: [FireDAC][Stan][Def]-254. Definition [TRADINGDB] is not found in []. Where TRADINGDB is the database we are connecting to.

The connection string on the connection manager is defined as
FireDAC?AuxDriver=MSSQL;Server=%s;Database=%s;Schemas=1;Integrated Security=SSPI;

%s is replaced on RunTime for the proper values.

The problem goes away if we include a FDConnectionDefs.Ini file on the server deployment where we specify

[TRADINGDB]
Server=HQ-DEV-DB-01
Database=TRADINGDB
OSAuthent=Yes
DriverID=MSSQL

Is there a way to avoid using the INI file. We dont want to deploy the .INI file with the server.

Thank you.

2

I can’t reproduce this issue with simple testcase.
I’ve set connection string in run-time as

  ServerDataModule.ConnectionManager.Connections[0].ConnectionString :=
     Format('FireDAC?AuxDriver=MSSQL;Server=%s;Database=%s;UserID=%s;Schemas=1;',
     [Edit1.Text,Edit2.Text,Edit3.Text]);
  ServerDataModule.Server.Active := True;

and compiled server executable works without any .ini.