propelorm/Propel2

SQLSTATE[IMSSP]: An invalid keyword 'user' was specified in the DSN string Propel2-Beta4

Opened this issue · 0 comments

propel init create a wrong DSN when pdo_sqlsrv driver is selected.
I observed line 389 in the InitCommand.php literally inserts user and password into the DSN as shown in the code snippet below. This in turn results to SQLSTATE[IMSSP] error being thrown later when the DSN is used in the PdoConnection.php to establish a connection to MSSQL server.

$fullDsn = sprintf('%s;user=%s;password=%s', $options['dsn'], urlencode($options['user']), urlencode($options['password']));

Changing the line to the snippet below fixes the problem but I suppose this might in turn result to an error for the other drivers that requires/supports user and password in the DSN string.

$fullDsn = $options['dsn'];