Laravel连接MSSqL服务器可用于cli，但不能在浏览器中使用

问题描述

安装dll's以与MSSqL服务器一起使用后，命令php artisan migrate正确运行，并且在db中创建了表.因此，我认为该连接将对此应用程序有效.

After installing the dll's to use with MSSqL server, the command php artisan migrate ran correctly and the tables were made in the db. So I thought the connection would work for this application.

然后我使用命令php artisan make:auth(不使用db连接)来构架认证文件.

I then used the command php artisan make:auth (which doesn't use the db connection) to scaffold the authentication files.

现在，当我尝试注册任何人时，都会出现错误:

Now when I try to register anyone I get errors:

找不到驱动程序

和

找不到驱动程序(从......

Could not find driver (select count(*) from .....

现在，我尝试查看使用cli命令是否仍然有效，并且php artisan migrate:rollback和php artisan migrate仍然有效.

Now I tried to see if using the cli commands still work and both php artisan migrate:rollback and php artisan migrate still work.

环境:安装了xampp的Windows 7.版本:Laravel 5.4，php 7.1

Environment:Windows 7 with xampp installed.Versions: Laravel 5.4, php 7.1

没关系，但这是我的.env和database.php文件的一部分:

Not that it matters but here are parts of my .env and database.php files:

`database.php`
        'sqlsrv' => [
        'driver' => 'sqlsrv',
        'host' => env('DB_HOST', '10.0.0.40'),
        'port' => env('DB_PORT', '1433'),
        'database' => env('DB_DATABASE', 'sqlcon'),
        'username' => env('DB_USERNAME', 'sa'),
        'password' => env('DB_PASSWORD', 'test'),
        'charset' => 'utf8',
        'prefix' => '',
    ],

`.env`
DB_CONNECTION=sqlsrv
DB_HOST=10.0.0.40
DB_PORT=1433
DB_DATABASE=sqlcon
DB_USERNAME=sa
DB_PASSWORD=test

那么cli命令如何起作用而浏览器却不起作用?

So how come the cli commands work and the browser don't?

laravel是否不对cli和浏览器连接使用相同的配置?

Doesn't laravel use the same config for both cli and browser connections?

更新:添加了一些额外的信息

Update: added some extra info

配置文件(php.ini)路径:C:\ Windows

Configuration File (php.ini) Path: C:\Windows

已加载的配置文件:C:\ xampp \ php \ php.ini

Loaded Configuration File: C:\xampp\php\php.ini

扫描以下位置的其他.ini文件:(无)

Scan for additional .ini files in: (none)

已解析的其他.ini文件:(无)

Additional .ini files parsed: (none)

使用此显示我的php配置，它显示:

Used this to show my php configuration and it shows:

php -m命令显示:

The php -m command shows:

[PHP模块]

bcmath

...(另一些)

pdo_mysql

pdo_mysql

pdo_sqlite

pdo_sqlite

pdo_sqlsrv(已启用此功能)

pdo_sqlsrv (this one is enabled)

Phar

...

[Zend模块]

根据php -m，已启用pdo_sqlsrv，但在phpinfo页中找不到对此的任何引用.

According to php -m the pdo_sqlsrv is enabled, but I can't find any reference to it in the phpinfo page.

推荐答案

我认为已解决问题的东西

在php.ini中安装驱动程序时，我使用了以下行，因为这是扩展目录(extension_dir="C:\xampp\php\ext")中文件的名称:

What I thought had fixed the problem

When installing the driver in php.ini I used the following line as this was the name of the file in the extension directory (extension_dir="C:\xampp\php\ext"):

extension=php_pdo_sqlsrv_71_ts.dll

更改此目录中文件的名称以及php.ini文件中对该文件的引用，然后重新启动apache，即可解决此问题.

Changing both the name of the file in this directory and the reference to it in the php.ini file and restarting apache solved the problem.

所以现在文件是php_pdo_sqlsrv.dll，引用是:

So now the file is php_pdo_sqlsrv.dll and the reference is:

extension=php_pdo_sqlsrv.dll

实际上是什么解决了问题

在下载此 >并更改为php.ini.

What actually fixed the problem

Installing this after downloading the dlls and making the change to php.ini.

别忘了重新启动apache.

这篇关于Laravel连接MSSqL服务器可用于cli，但不能在浏览器中使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！