This is how I’m connecting to the Db.
'connectionString' => 'sqlsrv:server=(local);Database=IMDB',
I was able to communicate with the DB and create a user Model and CRUD
However when changing to use the user table to authenticate (instructions from: http://www.yiiframework.com/wiki/80/add-information-to-yii-app-user-by-extending-cwebuser-better-version/)
When I try to login, yii gets the record of the user with case sensitive field names and yii active record and
db\schema\CDbCommandBuilder.php try to access the fields with lowercase.
Any suggestions ?
Thanks in advance.
I just changed my class UserIdentity class to use the right case for the login and password fields.
But I guess that I’m going to continue referring to the fields using the proper case as they are defined in the mssql database. I wish I could find a way to disable the cases sensitive field names.