Laravel和MS SQL Server数据库连接抛出错误“(3/3)QueryException找不到驱动程序". [英] Laravel and MS SQL Server Database connection is throwing the error "(3/3) QueryException could not find driver"

查看：170 发布时间：2020/4/28 4:40:52 php sql-server laravel laravel-5 database-connection

本文介绍了Laravel和MS SQL Server数据库连接抛出错误“(3/3)QueryException找不到驱动程序".的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

Guys, I tried lots of things mentioned in Stackoverflow and laracasts for this issue but none worked, hence posting this in hope of getting some answer or advice.另外，提供的大多数内容都属于MYSQL，而不是MS SQL.

Guys, I tried lots of things mentioned in Stackoverflow and laracasts for this issue but none worked, hence posting this in hope of getting some answer or advice. Also, most of the things provided belongs to MYSQL not for MS SQL.

我正在使用Windows 10，并使用Laravel连接到我的Microsoft SQL Server 2012 Express版本.

I am using Windows 10 and using Laravel to connect to my Microsoft SQL Server 2012 Express edition.

我的.erv文件如下:

I have the .erv file as following:

DB_CONNECTION=sqlsrv
DB_HOST=W1234567\SQLEXPRESS
DB_PORT=1433
DB_DATABASE=My_Database_Name
DB_USERNAME=sa
DB_PASSWORD=My_Password

给出的详细信息是正确的，但是当我运行一个简单的查询时，我的Laravel Model中收到以下错误消息:

The given details are correct but when I am running a simple query I am getting following error message in my Laravel Model:

(3/3) QueryException
could not find driver (SQL: SELECT COUNT(*) AS count FROM TBL_Data
WHERE ACTIVE_IND = 1
)

我的WAMP运行正常，已将SQLSRV文件添加到我的WAMP中.

I have the WAMP running properly, I have added the SQLSRV file to my WAMP.

整个过程运行良好，现在我将代码移到了其他系统，我得到了这个错误(两个系统具有相同的凭据，但更改的只是我更改过的服务器名称)，因此代码应该可以正常工作没有做任何更改.

The entire thing was working fine, now I moved the code to different system there I am getting this error (Both the system has the same credentials only change is the Server name which I have changed) so the code should work properly as there are no changes done.

我尝试检查SQL Server Configuration Manager中的SQL Server TCP/IP端口号，并将其更改为1433仍然没有运气.

I tried checking the SQL Server TCP/IP port number in SQL Server Configuration Manager and changed it to 1433 still no luck.

我在这里检查了大多数答案，这些答案属于PDO异常，并要求人们取消注释extension=php_pdo_mysql.dll的部分，但在我来说，它的SQL Server和正常的wamp正常工作仅是LARAVEL的问题.

I checked most of the answers here and they belong to PDO exception and asked people to uncomment the part extension=php_pdo_mysql.dll but in my case its SQL Server and normal wamp is working perfectly only seems to be problem with LARAVEL.

有人可以为此提供解决方案吗?

Can anyone provide the solutions for this?

Edited part below with some more info:

我检查了给定的凭据是否正确，以及是否能够使用控制器中的一个简单功能连接到数据库: 我的路线:Route::get('/Test', 'My_Controller@Test');

I checked if the credentials given are correct and if I am able to connect to db using a simple function in controller: My Route: Route::get('/Test', 'My_Controller@Test');

我的控制器:

public function Test(Request $request)
{
  if(DB::connection()->getDatabaseName())
   {
    echo "connected successfully to database ".DB::connection()->getDatabaseName();
  }

}

Chrome窗口中的输出:connected successfully to database My_Database_Name

Output in the Chrome window: connected successfully to database My_Database_Name

从上面的消息中我们可以看到，我能够正确连接，但是在运行查询时仍然出现错误:

As we see from above message, I am able to connect properly but still when I run the query I get the error:

(3/3) QueryException
could not find driver (SQL: SELECT * FROM TBL_Data WHERE ACTIVE_IND = 1 )

在控制器中添加了phpinfo();并尝试访问该URL，并获得了与PDO相关的以下信息:

Added the phpinfo(); in the controller and tried to hit the URL and got the following info related to the PDO:

PDO support enabled

PDO drivers mysql, SQLite

未启用SQLSRV，这是引起问题的原因吗?

SQLSRV is not enabled here is this something which is causing the issue?

Laravel和MS SQL Server数据库连接抛出错误“(3/3)QueryException找不到驱动程序". [英] Laravel and MS SQL Server Database connection is throwing the error "(3/3) QueryException could not find driver"

问题描述

推荐答案

相关文章

PHP最新文章

热门教程

热门工具

登录关闭

Laravel和MS SQL Server数据库连接抛出错误“(3/3)QueryException找不到驱动程序". [英] Laravel and MS SQL Server Database connection is throwing the error &quot;(3/3) QueryException could not find driver&quot;

问题描述

推荐答案

相关文章

PHP最新文章

热门教程

热门工具

登录 关闭

Laravel和MS SQL Server数据库连接抛出错误“(3/3)QueryException找不到驱动程序". [英] Laravel and MS SQL Server Database connection is throwing the error "(3/3) QueryException could not find driver"

登录关闭