When using Laravel on Ubuntu, an unsupported property was specified on the PDO object: MSSQL-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

When using Laravel on Ubuntu, an unsupported property was specified on the PDO object: MSSQL

P粉301523298 2023-10-30 23:05:50

657

My Ubuntu vagrant Laravel Homestead setup is configured to connect to MSSQL. Randomly, it started throwing the following error on every query that goes into the MSSQL database (on a Windows server).

Any ideas? I can't find much information about re:this on Google.

I restarted PHP and confirmed that the SQLSRV module was 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)

P粉301523298

reply all (1)

P粉1986706032023-10-31 21:46:52 1 floor

Check this problem reportPDO::ATTR_PERSISTENTNot supported. They also reported issues withPDO::ATTR_ERRMODE, so please check the connection of those two parameters.