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.
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.