使用PHP连接SQL Server：Laravel 5.3 [重复]

Question

This question already has an answer here:

• exception 'PDOException' with message 'could not find driver' SQLSRV Laravel Artisan CLI 2 answers

Inside config\database.php below setting is changed from mysql to sqlsrv

'default' => env('DB_CONNECTION', 'sqlsrv'),

In connection list added the below code.

'sqlsrv' => [
    'driver' => 'sqlsrv',
    'host' => 'Pankaj\SQLEXPRESS', 
    'database' => 'pankaj',
    'username' => 'sa',
    'password' => 'pankaj',
    'prefix' => '',
]

Inside .env file below are the modifications for Sql Server

DB_CONNECTION=sqlsrv
DB_HOST=Pankaj\SQLEXPRESS

DB_DATABASE=Pankaj
DB_USERNAME=sa
DB_PASSWORD=pankaj

Error Details

PDOException in Connector.php line 119: could not find driver

</div>

Answer 1

edit your php.ini file look up for this line:

;extension=pdo_mysql.so

remove the leading ; then restart your server