mssql connector, case sensitive issue when trying to login


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:

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.