Hi Robert,

PB Runtime Package is an MSI program. Thus its silent install command could be:

PBCLTTR190.msi /qn /l c:\temp\install.log

However, before installing the PB Runtime Package, you should copy three DLLs  (msvcr100.dll and msvcp100.dll atl100.dll) from Microsoft to the installation directory first. Otherwise, PBjvm190.dll will fail to be registered, it will also lead to the failure of installing MSI, including Silent install.

Please refer to the link below for more details:

https://docs.appeon.com/appeon_online_help/pb2019r2/application_techniques/ch36s03.html#Microsoft_files

If you want to silent install it successfully, you should copy those three Microsoft DLLs to the installation directory first, you can also copy them to Windows\System32 (64-bit) or Windows\SysWOW64 (32-bit).

Note: These three DLLs have 32-bit and 64-bit. You can obtain these DLL files from the %Appeon%\Shared\PowerBuilder (for 32-bit) or %Appeon%\Shared\PowerBuilder\x64 (for 64-bit) folder.

Furthermore, if you want to register the DLL to GAC by yourself, you can use the following command:

gacutil.exe /i Sybase.PowerBuilder.DataWindow.Excel12.dll

Please refer to the link below for more details:

https://docs.microsoft.com/en-us/dotnet/framework/app-domains/install-assembly-into-gac

Besides, in PB 2019 R2, you don’t need to register the excel DLL anymore.

Regards,

Ken

OK, but what about getting the dll's into the GAC on the client machine?  The MSI does that as part of the install for a reason.  So, I'm guessing I need to get that in there too somehow.

I'm referring to this section of the Runtime Packager Help file:

If your application saves DataWindow or graph data in Microsoft Excel 2007 format, select the MS Excel12 Support check box.

The Runtime Packager adds the PBDWExcel12Interop190.dll and Sybase.PowerBuilder.DataWindow.Excel12.dll files to the MSM or MSI package that you generate. It does not add the .NET Framework that is also required for Microsoft Excel 2007 support.

The Sybase.PowerBuilder.DataWindow.Excel12.dll file will be installed to the Windows GAC folder, for example, C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Sybase.PowerBuilder.DataWindow.Excel12, when you run the MSM or MSI.

When it says "it does not add the .NET Framework that is also required", which framework would that be?  So, I'm guessing I have to figure out if the user has that on their machine and if not, force that to be installed as well?

How can I add these DLL's to the GAC on a client machine from a command prompt.  Or, how can I get the MSI to install silently on a client machine?

There is a new feature added to PowerBuilder 2019 R2 that allows you to call .NET DLLs natively from PowerScript.  As Bruce Armstrong mentions in this post (https://community.appeon.com/index.php/qna/q-a/net-importer-tool), one benefit is you don't have to deal with GAC.