Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: Deploying a C++ Windows App using a FireDAC connection


This question is answered. Helpful answers available: 0. Correct answers available: 1.


Permlink Replies: 5 - Last Post: Aug 31, 2017 2:19 PM Last Post By: Paul Jackson Threads: [ Previous | Next ]
Paul Jackson

Posts: 51
Registered: 3/2/17
Deploying a C++ Windows App using a FireDAC connection  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 4, 2017 2:34 PM
Hello all,

Can someone enlighten me on how to deploy a simple Windows app that use a FireDAC connection to a PostgresSQL DB on a LAN? So I'm testing right now and learning how to build DB apps for Window 10. My test works fine on my build PC and it works fine. The UI comes up and I can play round with the data, etc.. Now I take the entire build folder and copy it to another PC on my network and run the program and nothing happens. I look in the Task Manager I can see the program for a few minutes then it disappears? I know that PG server is running and making remoter connections, but nothing happens.

Thank you for any advice

--
-Paul

Greg Reese

Posts: 85
Registered: 7/15/05
Re: Deploying a C++ Windows App using a FireDAC connection
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 7, 2017 6:12 AM   in response to: Paul Jackson in response to: Paul Jackson
Paul Jackson wrote:
build folder and copy it to another PC on my network and run the program and nothing happens. I look in the Task Manager I can see the program for a few minutes then it disappears? I know that PG server is running and making remoter connections, but nothing happens.
It sounds like the program is trying to connect but eventually times out.

Are the port numbers (for connecting to the db) on the development and deployment machines the same?

You can deploy FDAdministrator.exe (in the bin directory of your Builder installation) with your program

http://docwiki.embarcadero.com/RADStudio/Tokyo/en/FDAdministrator

to test your connection from the deployment machine. It will let you tweak the connection parameters.

Greg Reese
Paul Jackson

Posts: 51
Registered: 3/2/17
Re: Deploying a C++ Windows App using a FireDAC connection  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 7, 2017 9:56 AM   in response to: Greg Reese in response to: Greg Reese
Greg Reese wrote:
Paul Jackson wrote:
build folder and copy it to another PC on my network and run the program and nothing happens. I look in the Task Manager I can see the program for a few minutes then it disappears? I know that PG server is running and making remoter connections, but nothing happens.
It sounds like the program is trying to connect but eventually times out.

Are the port numbers (for connecting to the db) on the development and deployment machines the same?

You can deploy FDAdministrator.exe (in the bin directory of your Builder installation) with your program

http://docwiki.embarcadero.com/RADStudio/Tokyo/en/FDAdministrator

to test your connection from the deployment machine. It will let you tweak the connection parameters.

Greg Reese

Thank you for answering Greg. It turns out that I was missing a bunch of files for the deployment. I ended using InstallAware and using the Scan feature, it gathered up all the .dll's and such that were missing. Finally got it running.

But I would like to know exactly what files I need for different deployment. It put somewhere on the order of 30-40 .dll's and other supporting files into the distribution? I can't seem to find much information on what's needed.
--
-Paul

Edited by: Paul Jackson on Aug 7, 2017 8:18 PM
Greg Reese

Posts: 85
Registered: 7/15/05
Re: Deploying a C++ Windows App using a FireDAC connection
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 9, 2017 6:12 AM   in response to: Paul Jackson in response to: Paul Jackson
Paul Jackson wrote:
Greg Reese wrote:
Paul Jackson wrote:
But I would like to know exactly what files I need for different deployment. It put somewhere on the order of 30-40 .dll's and other supporting files into the distribution? I can't seem to find much information on what's needed.
--
-Paul

Edited by: Paul Jackson on Aug 7, 2017 8:18 PM

Some suggestions for determining which runtime packages you need are at
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Deciding_Which_Runtime_Packages_to_Use

Related information is at
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Deploying_General_Applications

Greg Reese
Paul Jackson

Posts: 51
Registered: 3/2/17
Re: Deploying a C++ Windows App using a FireDAC connection  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 9, 2017 4:27 PM   in response to: Greg Reese in response to: Greg Reese
Greg Reese wrote:
Paul Jackson wrote:
Greg Reese wrote:
Paul Jackson wrote:
But I would like to know exactly what files I need for different deployment. It put somewhere on the order of 30-40 .dll's and other supporting files into the distribution? I can't seem to find much information on what's needed.
--
-Paul

Edited by: Paul Jackson on Aug 7, 2017 8:18 PM

Some suggestions for determining which runtime packages you need are at
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Deciding_Which_Runtime_Packages_to_Use

Related information is at
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Deploying_General_Applications

Greg Reese

Hi Greg. Yeah I've read the Deploying Gen App link, and bunches of others, but had not seen the Deciding_Which_Runtime...

So thank you for the link, but even though I have the run-time packages on and linked, there is nothing showing up in the event log as the article suggests?

What do you do for deployment? How are you gathering the files your programs need?
--
-Paul
Paul Jackson

Posts: 51
Registered: 3/2/17
Re: Deploying a C++ Windows App using a FireDAC connection  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 31, 2017 2:19 PM   in response to: Paul Jackson in response to: Paul Jackson
So it turns out that I needed certain client libraries as well as supporting dll's which were not present. After spending much time reading/researching I got it figured out. This link was very helpful too:
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/File_Types_Index

specifically the .PDI file which shows you what base supporting dll's you need. Add in the client libraries for your DB server and Voila! You're in business. This information in the .PDI file is also what is shown in the Information Dialog under the Project menu if you're building in Debug mode.

Anyway it works, and I am now a happier person this day!

Paul Jackson wrote:
Hello all,

Can someone enlighten me on how to deploy a simple Windows app that use a FireDAC connection to a PostgresSQL DB on a LAN? So I'm testing right now and learning how to build DB apps for Window 10. My test works fine on my build PC and it works fine. The UI comes up and I can play round with the data, etc.. Now I take the entire build folder and copy it to another PC on my network and run the program and nothing happens. I look in the Task Manager I can see the program for a few minutes then it disappears? I know that PG server is running and making remoter connections, but nothing happens.

Thank you for any advice

--
-Paul


--
-Paul
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02