79576971

Date: 2025-04-16 10:42:30
Score: 0.5
Natty:
Report link

After several weeks of discussion with Microsoft, it appear that this is because Warehouse doesn't support Multiple Active Result Sets (MARS). Setting MultipleActiveResultSets=0 in option resolve the problem.

so, the final method for me was :

        $connectionParams = [
            'dbname' => 'my_DBname',
            'user' => [email protected]',
            'password' => 'mypassword',
            'host' => 'xxxxxxxxxxxxxx.datawarehouse.fabric.microsoft.com',
            'driver' => 'pdo_sqlsrv',
            'port' => 1433,
            'driverOptions' => [
                'Authentication' => 'ActiveDirectoryPassword',
                'MultipleActiveResultSets' => 0,
                'Encrypt' => 1,
                'TrustServerCertificate' => true
            ]
        ];
        $this->conn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams);
Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: julien boucheron