Doctrine configuration in Zend Framework 3

Question

I am using Zend Framework 3 for my project. I would like to use Doctrine with Sql Server 2014. When I use Zend-Db all things are fine but using Doctrine displays me this message:

Fatal error: Invalid handle returned. in C:\Users\root\zendwithsqlserver\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php on line 43

I have done all configurations needed for doctrine First I config my sql server database credentials in config/autoload/local like this:

<?php 
use Doctrine\DBAL\Driver\PDOSqlsrv\Driver as PDOSqlsrvDriver;
return array(
'doctrine' => [
    'connection' => [
        'orm_default' => [
            'driverClass' => PDOSqlsrvDriver::class,
            'params' => [
                'host'     => 'localhost',
                'user'     => 'sa',
                'password' => 'mypassword',
                'dbname'   => 'blog',
            ]
        ],
    ],
],
);

To finish in my module.config.php file located in module/Application/module/ I add the doctrine code to permit it to know where are situated my entities .

'doctrine' => [
    'driver' => [
        __NAMESPACE__ . '_driver' => [
            'class' => 'Doctrine\ORM\Mapping\Driver\AnnotationDriver',
            'cache' => 'array',
            'paths' => [__DIR__ . '/../src/Entity']
        ],
        'orm_default' => [
            'drivers' => [
                __NAMESPACE__ . '\Entity' => __NAMESPACE__ . '_driver'
            ]
        ]
    ]
]

I would like to know how can I fix this error?:

Fatal error: Invalid handle returned. in C:\Users\root\zendwithsqlserver\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php on line 43

Any idea or suggestion is welcome, thanks in advance.

I didn't use doctrine with mssql but based on this question (https://stackoverflow.com/questions/38222539/unable-to-connect-to-sql-server-with-php/38517951#38517951), can you add `ConnectionPooling => 0` to your config? — Mehmet SÖĞÜNMEZ, Mar 13 '18 at 13:28
Even if I add `ConnectionPooling => 0` I have the same error — SANDWIDI, Mar 13 '18 at 13:56

score 0 · Answer 1 · answered May 22 '18 at 05:07

Please change the local.php as below code.

<?php
use Doctrine\DBAL\Driver\SQLSrv\Driver as SQLSrvDriver;

return [
   'doctrine' => [
       'connection' => [
           'orm_default' => [
               'driverClass' => SQLSrvDriver::class,
               'params' => [
                   'host'     => 'USER-PC\MYINSTANCE',                    
                   'user'     => 'sa',
                   'password' => 'mypassword',
                   'dbname'   => 'blog',
                   'port'     => '49166'
               ]
           ],            
       ],        
   ],
];

Please refer this link to find the mssql port number : Identify Port used by SQL Server Database Engine Using SQL Server Configuration Manager

Doctrine configuration in Zend Framework 3

1 Answers1