Tuesday, February 3, 2015

A fix for Assignment 3

There is a permissions error in the Fan log in. To fix it Go to TOOLS in the Visual Studio menu, choose SQL, NEW QUERY. Connect the database to .\sqlexpress. Type in the following SQL.

Use ShowTracker
Grant Select on FanLogin to FanRole

Once you run this code you should have the permissions you need


There are a couple of other common problems.

In the Login class there is a line (47) that assigns the userkey to key

  key = u.ReviewerKey;

For some reason with the showtracker database we have to cast this to an int

  key = (int)u.ReviewerKey;

Finally, be aware the random seed that is concatenated with the password is "LoginRandom" in the fanlogin table, not "FanKey" or "FanLoginKey."

No comments:

Post a Comment