1. Sverre Tvedt
  2. PowerBuilder
  3. Saturday, 19 August 2023 23:17 PM UTC

Hi folks

 I have upgraded to 2022 R2  and am testing deployment of our appliications using the latest runtime in IDE AND in the projects.

Windows 10/64bit  &  32 bit IDE/project

 

I try to connect to MS SQL Server (2014)

using the following transaction object parameters

it_systransobj:

   autocommit = true
   database ="dbname"
   dbms="ADO.Net"
   dbparm="Provider='SQL Server',TrimSpaces=1,CommandTimeOut=60, DataSource='servername,1433',Database='dbname'"
   dbpass="password"
   lock=""
   logid="username"
   logpass="password"
   servername="servername"
   userid="username"

 

This works fine in the IDE, but not in deployment.

when the deployed application executes :

messagebox("connect server", it_systransobj.dbparm)

 connect using it_systransobj;

messagebox("connected to server","result")

then it shows the dbparm parameter , and on pressing OK it simply silently halts, never reaching the final messagebox, and it is not possible to pull any errormessage from that transaction object.

I have carefully collected all the listed runtime components supplied in the documentation for R2 and put them in our conventional runtimefolder on the clientside (included in the client's  path).  No change from previous versions here, just replaced the old sybase.xxx.xxx.xxx components. Every other runtime component is also updated to build R2 2819, of course.

Also, I have installed .NET Desktop Runtime 6.x on the test client machine and rebooted.

This looks like something is missing on the deployed client side, since it works in the IDE.

Any others with similar experiences?  And solutions :)

 

 

Sverre Tvedt Accepted Answer Pending Moderation
  1. Sunday, 27 August 2023 20:35 PM UTC
  2. PowerBuilder
  3. # 1

Problem solved:

Needs to be installed on client:

NET 6.0 Desktop Runtime X86

The version deployed turned out to be the 64 bit version.

 

Thanks everyone for suggestions, and many thanks for the patience endured by the bug report team :)

Comment
  1. Armeen Mazda @Appeon
  2. Monday, 28 August 2023 16:33 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 22 August 2023 05:00 AM UTC
  2. PowerBuilder
  3. # 2

Hi Sverre,

 

In order to apply this workaround, you should add 

Ijwhost.dll

to you runtime file package.

 

Best Regards,

Peter

Comment
There are no comments made yet.
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Monday, 21 August 2023 06:40 AM UTC
  2. PowerBuilder
  3. # 3

Hi Sverre,

 

Thanks for reporting this problem. We reproduced it on our end.

Workaround: Select .NET Assembly Calls in Runtime Packager and select dotNET Assembly Calls in Powerclient/PowerServer Runtime.

 

 

Best Regards,

Peter

Comment
  1. Peter Pang @Appeon
  2. Tuesday, 22 August 2023 04:13 AM UTC
List of ADO.NET for SQL Server runtime files:

Ijwhost.dll //add

pbDBDriver.dll

Appeon.DB.Proxy.dll

Appeon.DB.Proxy.runtimeconfig.json

Appeon.DB.Proxy.deps.json

Appeon.DB.Base.dll

Appeon.DB.Base.deps.json

Appeon.DB.SQLServer.dll

Appeon.DB.SQLServer.deps.json

Microsoft.Data.SqlClient.dll

Microsoft.Data.SqlClient.SNI.dll

Microsoft.Identity.Client.dll

Microsoft.SqlServer.Server.dll

System.Configuration.ConfigurationManager.dll

System.Security.Permissions.dll

Azure.Core.dll

Azure.Identity.dll

Microsoft.Bcl.AsyncInterfaces.dll

Microsoft.Identity.Client.Extensions.Msal.dll

Microsoft.IdentityModel.Abstractions.dll

Microsoft.IdentityModel.JsonWebTokens.dll

Microsoft.IdentityModel.Logging.dll

Microsoft.IdentityModel.Protocols.dll

Microsoft.IdentityModel.Protocols.OpenIdConnect.dll

Microsoft.IdentityModel.Tokens.dll

Microsoft.Win32.SystemEvents.dll

System.Drawing.Common.dll

System.IdentityModel.Tokens.Jwt.dll

System.Memory.Data.dll

System.Runtime.Caching.dll

System.Security.Cryptography.ProtectedData.dll

System.Windows.Extensions.dll

  1. Helpful
  1. Sverre Tvedt
  2. Tuesday, 22 August 2023 07:46 AM UTC
Have been there all the time, including Ijwhost.dll. The collection of runtime files has been carefully checked against the documention multiple times.

The exe file and several other resources are placed on a file server and the runtime files( dlls and others) in a folder on the client, available to the client users Windows Path. This is a structure that we have had for twenty years now.

We have also tried putting the DB-related dll components on the file server, together with the exe file. No change.
  1. Helpful
  1. Peter Pang @Appeon
  2. Tuesday, 22 August 2023 09:46 AM UTC
Please open a ticket through our support portal at https://www.appeon.com/standardsupport/newbug.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.