Yii2 With SQL Server - Model Generator Error

thaer.aliat · October 5, 2018, 7:38pm

Hello,

I need to generate a models and CRUD using yii2 Gii with sql server database tables , but when i am trying to generate model, yii2 return the following error, so how can i solve this problem please.

Database Exception – yii\db\Exception SQLSTATE[42S02]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name ‘dbo.INFORMATION_SCHEMA.KEY_COLUMN_USAGE’.

Thanks in advance

wilsonxyz · October 6, 2018, 3:59am

I think it was same problem here.

but already solved. try to update your yii2 version

samdark · October 7, 2018, 3:58pm

Seems it’s fixed in Yii 2.0.13.1. What version you have problem with?

rafey022 · October 17, 2022, 6:30am

How to generate CRUD with MSSQL?