Having problems with login varification SQL!

[Guest]

Hi guys,
I am building a login page using DW's SQL building tool. but login is failing though all seems well.
I built a simple query to test that it was accessing the database and that returned the requested data though when I run the login page I get redirected to the login failure page that I have put in place! I can't see where the problem is.
Has anybody got any sugestions?

Any help appreciated

Rob Ford

[Guest]

check the access level while you use the server behaviour to check username.

[Guest]

Hi Pete,
Thanx for the input.
I'm not sure which access level you mean.
The username/password I use for the MYSQL Db has been set up with full privileges and the "login page" dialogue in DW has been set up with verify by "username and password" only rather than with the access level option. I have checked all that I can think of including the entries in the Db to make sure there are no spelling or case mistakes.

Regards

Rob