1. Winthor Caingles
  2. PowerBuilder
  3. Thursday, 27 May 2021 02:01 AM UTC

Good day,

Need help for the powerclient... I read this article indicating the steps on the deployment.

"

Advanced usage of External Files and Preload Event

The combination of External Files and Preload Event can streamline the process of deploying a setup package to the server, installing the package and registering the file on the client machine. In the External Files page, you add the folders and/or files that make up of the setup package, and in the Preload Event field, you add commands to run the setup file and register any component if necessary.

Take Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) as an example. Suppose the MSOLEDBSQL setup package includes the following folders and files: msoledbsql folder, sqlncli folder, CheckDBDriver.bat file, and Install.bat file.

Step 1: Copy the msoledbsql folder, sqlncli folder, CheckDBDriver.bat file, and Install.bat file to the same folder as the application target file.

Step 2: In the External Files page, select Files (Download at startup) in the list, and then click Add Folder to add the folders: msoledbsql and sqlncli and click Add Files to add the files: CheckDBDriver.bat and Install.bat.

The selected folders and files will be first deployed to the server and then downloaded to the application directory on the client machine.

Step 3: In the Run Options page, add the following command in the Preload Event field: .\CheckDBDriver.bat.

The command will be executed automatically when the application is first installed or upgraded. The CheckDBDriver.bat file checks whether MSOLEDBSQL is installed on the client machine. If MSOLEDBSQL is not installed, then Install.bat is automatically run to install MSOLEDBSQL. Administrator rights are required to run the Install.bat file, so the end user will be prompted for that if Install.bat is run."

 

Can I ask on the script of CheckDBDriver.bat and Istall.bat ? and also, how to install font at first installation. the problem right now is that every time I update the system, the font istaller and the msoledbsql run again... 

 

thank you for your help.

Accepted Answer
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 27 May 2021 06:31 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Winthor,

For the script of CheckDBDriver.bat and Istall.bat, you can download them from the link below:
https://download.appeon.com/software/InstallDBDriver.zip

For the font issue, I have no experience with it. You can check if the font is already installed before installing it, please refer to the article below for details.
https://tailormade.com/ax2020techdocs/troubleshooting/windowsisfontinstalled/

Regards,
ZhaoKai

Comment
  1. Winthor Caingles
  2. Thursday, 27 May 2021 07:48 AM UTC
thank you...it helps alot... one more thing, how can I automatically add font ?
  1. Helpful
  1. Kai Zhao @Appeon
  2. Friday, 28 May 2021 01:25 AM UTC
Hi Winthor,



if the font file is exe, you can run it in bat file. If it is a ttf file, you can copy it to C:\Windows\Fonts in bat, which might require admin permission.



Regards,

ZhaoKai

  1. Helpful
  1. Winthor Caingles
  2. Friday, 28 May 2021 06:30 AM UTC
thank you
  1. Helpful
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.