-
Ramendra Singh
- PowerBuilder
- Thursday, 12 June 2025 05:32 AM UTC
Hi Gurus
We are using PowerBuilder 2023R3, Sybase ASE 6.0 and SQL Server 19.
We have noticed that in certain condition, PB Client is creating a new connect to DB when doing a select to address table to fetch existing data.
-
Create New Account
-
Goto - Statement Tab
-
Link Address
-
Search for existing address to be picked
-
At this time of search, new connection created
-
-
Create new address and save
Note: We are using a single Global Transaction Object. The select query is written in datawindow.
If I convert this DW select query with Stored Procedure DW, PB don't create a new connection.
Checking if there is a way to stop PB creating a new DB connection by changing connection parameter without converting the DW into Stored Procedure.
Please let me know if any further details needed.
Thanks
Ramendra
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.