-
Pieter Coene
- PowerBuilder
- Friday, 20 June 2025 02:21 PM UTC
Hello,
i want to test if our powerbuilder application can connect to a "Read-only Replica" (https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql#connect-to-a-read-only-replica) using the "ApplicationIntent=ReadOnly" property.
I'm not finding any info on this on how to achieve this in my connectionstring from PB. I tested using this string as my "dbParm" of the MS SQL connection.
DbParm=Database='<our DB>',Provider='MSOLEDBSQL19',ProviderString='ApplicationIntent=ReadOnly'
But the property is not picked up and i end up connection to my 'production' db, and not the "Read-only Replica"...
Has anyone more info on this?
Greetz
Pieter
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.