When using pdo_sqlsrv adapter there is no possibility to pass driver_options like MultiSubnetFailover=yes that have to be part of the the dsn.
Instead, driver_options and options key in config are both passed as pdo options.
It works when using sqlsrv or setting the whole dsn string manually.
Driver options must always be part of the connection string and are NOT pdo options, see:
https://learn.microsoft.com/en-us/sql/connect/php/php-driver-for-sql-server-support-for-high-availability-disaster-recovery?view=sql-server-ver16#transparent-network-ip-resolution-tnir
Please fix - Thanks
When using pdo_sqlsrv adapter there is no possibility to pass driver_options like MultiSubnetFailover=yes that have to be part of the the dsn.
Instead, driver_options and options key in config are both passed as pdo options.
It works when using sqlsrv or setting the whole dsn string manually.
Driver options must always be part of the connection string and are NOT pdo options, see:
https://learn.microsoft.com/en-us/sql/connect/php/php-driver-for-sql-server-support-for-high-availability-disaster-recovery?view=sql-server-ver16#transparent-network-ip-resolution-tnir
Please fix - Thanks