FireDac Win 64 Execuatble Missing Connection

[Andrew McIsaac]

Good afternoon everyone,
Lots of help from Embarcadero - can now create Firedac SQLite Execuatble win64bit Multidevice application

Last issue is - I have FireDac connecting to SQLite on development machine.
If database and table do not exist, it creates

FDConnection_DUC->ConnectionDefName="DUC_2020";
FDConnection_DUC->Params->Database ="DUC_db.db";
FDConnection_DUC->Connected=true;


TabbedForm_Main->FDQuery_DUC->SQL->Clear();
TabbedForm_Main->FDQuery_DUC->SQL->Add("CREATE TABLE IF NOT EXISTS DUC_Themes (Themes TEXT NOT NULL, Active TEXT)");
TabbedForm_Main->FDQuery_DUC->ExecSQL();

Problem is, once compiled on another machine does not create a database
[FireDAC][Stan][Def]-254 Defintion [DUC_2020] is not found

ideas on how How to get this into the program ?
Thanks,

[Andrew McIsaac]

Solved by not using DefName
FDConnection :
ConnectionDefName - blank - not using this way
and ConnectionName = "Duc2020"

Thank you to Christopher for all the help at Embarcadero support - lots of emails over the past few weeks.



Andrew