FireDac Win 64 Execuatble Missing Connection

This is the forum for miscellaneous technical/programming questions.

Moderator: 2ffat

Post Reply
Andrew McIsaac
Active Poster
Active Poster
Posts: 17
Joined: Fri Nov 06, 2020 12:36 am

FireDac Win 64 Execuatble Missing Connection

Post by 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
Active Poster
Active Poster
Posts: 17
Joined: Fri Nov 06, 2020 12:36 am

Re: FireDac Win 64 Execuatble Missing Connection

Post by 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
Post Reply