we are using dbparm to connect to ms sql server 2019

SET %DBPARM%=TrustedConnection=1,Database='%Database_Name%',Provider='SQLNCLI11',AppName='ixapp',

Host='%username%.%computername%',Identity='SCOPE_IDENTITY()',Encrypt=1,TrustServerCertificate=1

where the server name is a listener

we can usually connect successfully, however, in some circumstances it may try to connect for a thousand times over the course of an hour before it successfully connects

The solution to this in other cases where we use the listener is to set

MultiSubnetFailover = true as a param passed to the connection object

I see pb has FailoverPartner but that does not seem to have the same function as listener + multisubnetFailover:

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnectionstringbuilder.multisubnetfailover?view=dotnet-plat-ext-6.0

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-ver16

FailOverPartner appears to require a mirror server name instead of using the listener defined failover server
my_trans.dbparm="FailoverPartner='myMirrorServer'"

What is the solution for this?