cakephp / phinx

        try {

            $db = new PDO($dsn, $username, $password, $options);

            foreach ($adapterOptions as $key => $option) {

                if (strpos($key, 'attr_') === 0) {

                    $pdoConstant = '\PDO::' . strtoupper($key);

                    if (!defined($pdoConstant)) {

                        throw new \UnexpectedValueException('Invalid PDO attribute: ' . $key . ' (' . $pdoConstant . ')');

                    }

                    $db->setAttribute(constant($pdoConstant), $option);

                }

            }

        } catch (PDOException $e) {

            throw new InvalidArgumentException(sprintf(

                'There was a problem connecting to the database: %s',

            // support arbitrary \PDO::SQLSRV_ATTR_* driver options and pass them to PDO

            // http://php.net/manual/en/ref.pdo-sqlsrv.php#pdo-sqlsrv.constants

            foreach ($options as $key => $option) {

                if (strpos($key, 'sqlsrv_attr_') === 0) {

                    $pdoConstant = '\PDO::' . strtoupper($key);

                    if (!defined($pdoConstant)) {

                        throw new \UnexpectedValueException('Invalid PDO attribute: ' . $key . ' (' . $pdoConstant . ')');

                    }

                    $driverOptions[constant($pdoConstant)] = $option;

                }

            }

            $db = $this->createPdoConnection($dsn, $options['user'], $options['pass'], $driverOptions);