Prev   Next

Back to the top of the FAQ

Q. The test button works fine, but I cannot login. I turned on "Show Reason in Access Denied Message" and it just says "Bad Password" :-(

A. Make sure that the DSN you are using is a System DSN. Other DSN's are not accessible to system processes such as IIS.
Also note that the "Test ODBC" button may work properly with non-text or multiple-word fields, but the web authentication may fail. Make sure you are using text fields and that the field names do not contain spaces.

The Test ODBC button differs from using the ODBC connection from the filter in the following ways:
1) The Test ODBC executes in the permission context of the logged in user. So if that user has permissions, all will go well for the Test button. However the ISAPI filter logs in as the system account, which usually will not have permission to access resources not on the local machine. If you need to access a database on another machine, try using the "Impersonate User when Accessing Database" settings.
2) The statement executed, does not include the where clause for the username. So it only executes
Select password from tablename
and comes back with a count of all users. As opposed to the ISAPI filter, which will execute
Select password from tablename where username='suppliedUsername',
and will come back with one entry, if there is a match for the username. Then the filter compares the returned password with the supplied password.

Back to the top of the FAQ

Prev   Next