Doctrine DBAL

PDO_Sqlsrv bug in _constructPdoDsn()

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Blocker Blocker
  • Resolution: Fixed
  • Affects Version/s: 2.0.0-BETA2
  • Fix Version/s: 2.0.0-BETA4
  • Component/s: Drivers
  • Labels:
    None
  • Environment:
    Windows 7, Zend Server CE, Sql Server driver for PHP v2

Description

When connection to mssql server with pdo_sqlsrv driver you get:

 
[PDOException]
SQLSTATE[IMSSP]: The DSN string ended unexpectedly.

Sample $connectionOptions:

$connectionOptions = array(
    'dbname' => 'AdventureWorks',
    'user' => 'sa',
    'password' => 'sa_password',
    'host' => 'local',
    'driver' => 'pdo_sqlsrv'
);

Error is in Doctrine\DBAL\Driver\PDOSqlsrv\Driver in function _constructPdoDsn(array $params).
On line 53 dsn starts with 

$dsn = 'sqlsrv:(';

instead of 

$dsn = 'sqlsrv:server=(';

as written in offical Microsoft help which come with SQL Server Driver For PHP v2.

Activity

Ascending order - Click to sort in descending order
Benjamin Eberlei made changes -
Field Original Value New Value
Assignee Benjamin Eberlei [ beberlei ] Juozas Kaziukenas [ juokaz ]
Benjamin Eberlei made changes -
Status Open [ 1 ] Resolved [ 5 ]
Assignee Juozas Kaziukenas [ juokaz ] Benjamin Eberlei [ beberlei ]
Fix Version/s 2.0.0-BETA4 [ 10071 ]
Resolution Fixed [ 1 ]
Benjamin Eberlei made changes -
Workflow jira [ 11665 ] jira-feedback2 [ 17652 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 17652 ] jira-feedback3 [ 20007 ]

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Bostjan Oblak
Vote (1)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: