Skip to main content
December 30, 2007
Question

Having problems with login varification SQL!

  • December 30, 2007
  • 2 replies
  • 300 views
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
This topic has been closed for replies.

2 replies

January 6, 2008
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
January 2, 2008
check the access level while you use the server behaviour to check username.