Prev   Next

Back to the top of the FAQ

Q. I have some questions about ODBC caching. I understand that the ODBC user requests are cached and there are settings to control expiration etc. If the request is authenticated from the cache does it look it up again real-time? (i.e. if a currently logged-on user changes password and the user id is located in the cache, will it re-validate or what will happen?

A. From the windows help file:

If you have set up and enabled an ODBC authorization database (see Set Up ODBC), you can adjust the following options:

  • Minutes between cache cleanup (default = 10) — The Software caches user lookups. This value determines how frequently the cache is emptied.
  • Minutes to discard old users (default = 10) — If a user has not accessed a protected directory in this number of minutes, the user is deleted from the cache.
  • Minutes between forced user lookup (default = 60) — Determines how frequently to check a user’s username and password. This feature makes it possible to “kick out” a user who has been accessing a protected directory continuously for a very long time. You can change his or her password., and after the number of minutes entered here, the user’s name and password will be checked and the user will be denied access to the protected directory.

You can use the ODBCRemoveUserFromCache OCX method to force a user to be removed from the cache,

Back to the top of the FAQ

Prev   Next

Special Keywords: odbc