Crotten
Posts: 12
|
| Posted: 04/04/2009, 2:01 AM |
|
Hi all, I am really new to this product, so please be gentle.
I've finally got the 20 day evaluation installed and working. I just built my first test project (quite easy I might add).
I am using ASP version.
Anyway, I've set a Return Page for my Login page to my mainmenu.
However, I can't get to the main menu because when I try to login to the SQL database, I keep getting Invalid Password or Login.
It makes no difference which account I use, either a User or Admin type account. I know the data is fine as I can login fine with another asp app.
Any pointers would be appreciated.
My security setup is like so:
UserID Field: Account Name (nvarchar)
LoginField: AccountID (nvarchar)
PasswordField: Acct_PSWD (nvarchar)
Level/Group Field: User_LVL (int: 1=user, -1 = admin. Higher DOES NOT include Lower. I Also tried it with HIGHER INCLUDES). Just can't login.
|
 |
 |
ckroon
Posts: 869
|
| Posted: 04/04/2009, 9:44 AM |
|
I am thinking you need to put a numeric value in UserID, not a varchar.
User ID shoul be a number
Login should be somethin like ckroon
_________________
Walter Kempees...you are dearly missed. |
|
|
|
damian
Posts: 838
|
| Posted: 04/05/2009, 5:45 AM |
|
i looked but couldnt find it specified anywhere but i also think it should be an integer value - should also be auto increment or you should have some other way to ensure that the numbers in this field are all unique.
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
|
