Laravel:在PDO对象上指定了不受支持的属性.Ubuntu上的MSSQL [英] Laravel: An unsupported attribute was designated on the PDO object. MSSQL on Ubuntu

问题描述

我的Ubuntu流浪汉Laravel Homestead设置已配置为连接到MSSQL.随机地，它开始对进入MSSQL数据库(在Windows服务器上)的每个查询引发以下错误.

My Ubuntu vagrant Laravel Homestead set up has been configured to connect to MSSQL. Randomly it's starting throwing the following error on every query going to the MSSQL database (on a Windows server).

有什么想法吗?我找不到很多信息:re:this在Google上可用.

Any ideas? I can't find much info re:this available on Google.

我重新启动PHP并确认已加载SQLSRV模块.

I restarted PHP and confirmed SQLSRV modules are loaded.

SQLSTATE[IMSSP]: An unsupported attribute was designated on the PDO object. (SQL: select top 10 * from [orders] where [ordertype] = SO order by [orderdate] desc)

推荐答案

检查此问题报告不支持 PDO :: ATTR_PERSISTENT .他们还报告了 PDO :: ATTR_ERRMODE 的问题，因此请检查您的连接是否有这两个参数.

Check this issue report PDO::ATTR_PERSISTENT is not supported. Also they are reporting problems with PDO::ATTR_ERRMODE so check your connection for these two parameters.

这篇关于Laravel:在PDO对象上指定了不受支持的属性.Ubuntu上的MSSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！