1. Gilcemar Guizzo Zanette
  2. PowerBuilder
  3. Friday, 22 April 2022 17:16 PM UTC

Hi.

 

Is it possible to share connection between programs?

Example.

First app developed with PB connects to a database.

Second app uses the first connection to comunicates with database.

 

Thanks.

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 April 2022 17:43 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Gilcemar ;

  • No .. that is governed by the Transaction object which is instantiated uniquely (has it's own O/S "handle) within each the App's "address space" which cannot be shared.
  • Yes ... if you use PB's Multi-threading feature as the "main" thread can connect & then pass the address of the "active" Transaction Object (own O/S "handle) to the other sub-threads to use.
  • Alternative #1 .. use DB Client's "Connection Pooling feature" (if it supports it).
  • Alternative #2 .. use PowerServer's "Connection Pooling feature". 

HTH

Regards ... Chris

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Friday, 22 April 2022 18:34 PM UTC
  2. PowerBuilder
  3. # 1
Comment
  1. Chris Pollach @Appeon
  2. Friday, 22 April 2022 18:42 PM UTC
Yes, for .NET Assemblies.
  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.