laravel连sql server报invalid handle returned问题解决方案

时间：2017-09-25 12:38:15 收藏：0 阅读：2662

https://github.com/Microsoft/msphpsql/issues/116

4.1.1驱动下载地址

https://github.com/Microsoft/msphpsql/releases/tag/v4.1.1-Windows

还有一说是

在数据库配置中加入 ‘pooling’ => false

‘sqlsrv’ => [
‘driver’   => ‘sqlsrv’,
‘host’     => ‘xxx’,
‘database’ => ‘xxx’,
‘username’ => ‘xxx’,
‘password’ => ‘xxx’,
‘charset’ => ‘utf8’,
‘prefix’   => ”,
‘pooling’ => false

或者

注释掉port这一行

‘connections‘ => [
        ‘sqlsrv‘ => [
            ‘driver‘   => ‘sqlsrv‘,
            ‘host‘     => env( ‘DB_HOST‘ ),
            ‘port‘     => ‘‘, // THIS LINE
            ‘database‘ => env( ‘DB_DATABASE‘ ),
            ‘username‘ => env( ‘DB_USERNAME‘ ),
            ‘password‘ => env( ‘DB_PASSWORD‘ ),
            ‘prefix‘   => ‘‘,
            ‘charset‘  => ‘UTF-8‘,
            ‘pooling‘  => false,
        ],
],

原文：http://www.cnblogs.com/yuanxiaoping_21cn_com/p/7591084.html