Custom Driver Options in DSN URL

[mvorisek]

This is a question.

Based on https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#custom-driver-options driverOptions can be used to specify driver specific options.

For MSSQL I need to specify TrustServerCertificate=1. How can I specify such option in DSN URL so it is parsed correctly to driverOptions array?

[morozov]

Something like this may work according to DriverManagerTest::testDatabaseUrl():

'Driver Options' => [
    [
        'url' => 'sqlsrv://localhost/foo?driverOptions[TrustServerCertificate]=1',
    ],
    [
        'driverOptions' => [
            'TrustServerCertificate' => 1,
        ],
    ],
],

[mvorisek]

Works like a charm, thank you!

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.