Laravel migration cannot find driver when using sqlsrv database in windows
I am using sqlsrv database connection in my project as I need to connect to Microsoft SQL Database.
I have successfully installed the sqlsrv driver because I can connect to the Database to retrieve data.
But when I try to do the Laravel Migration, it shows an error:
IlluminateDatabaseQueryException : could not find driver (SQL: select * from sysobjects where type = 'U' and name = migrations)
Below is my .env
DB_CONNECTION=sqlsrv
DB_HOST=**********.database.windows.net
DB_PORT=1433
DB_DATABASE=****************_4cd1_9d18_2a7d9ddbcd13
DB_USERNAME=***************_4cd1_9d18_2a7d9ddbcd13_ExternalWriter
DB_PASSWORD=***************
php.ini
extension=php_xmlrpc.dll
extension=php_xsl.dll
extension=php_pdo_sqlsrv_7_nts_x64.dll
extension=php_pdo_sqlsrv_7_nts_x86.dll
extension=php_pdo_sqlsrv_7_ts_x64.dll
extension=php_pdo_sqlsrv_7_ts_x86.dll
extension=php_pdo_sqlsrv_71_nts_x64.dll
extension=php_pdo_sqlsrv_71_nts_x86.dll
extension=php_pdo_sqlsrv_71_ts_x64.dll
extension=php_pdo_sqlsrv_71_ts_x86.dll
extension=php_sqlsrv_7_nts_x64.dll
extension=php_sqlsrv_7_nts_x86.dll
extension=php_sqlsrv_7_ts_x64.dll
extension=php_sqlsrv_7_ts_x86.dll
extension=php_sqlsrv_71_nts_x64.dll
extension=php_sqlsrv_71_nts_x86.dll
extension=php_sqlsrv_71_ts_x64.dll
extension=php_sqlsrv_71_ts_x86.dll
from Laravel Questions and Answers https://laravelquestions.com/laravel/laravel-migration-cannot-find-driver-when-using-sqlsrv-database-in-windows/
via Lzo Media
No comments:
Post a Comment