ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
E-1
E
Changing Passwords in a Three-Tier
Environment
A three-tier environment is a configuration of ODBC where the HP NonStop ODBC/MP
driver is invoked by an application server on behalf of a user application. Figure E-1
shows a typical three-tier configuration.
In the configuration shown, the HP NonStop ODBC Server cannot open a window on
the CLIENT platform to prompt for a new password when SERVER 2 determines that
the current user ID or password has changed.
The NonStop ODBC/MP driver has a facility that supports user change of password in
three-tier environments by allowing an application server to do one of the following:
•
Report detection of an expired password on the same platform where the NonStop
ODBC/MP driver is being executed and allow the user to change the password.
•
Provide its own secure paths by which the client can provide old and new
passwords so that a change can be effected to the server.
The user or administrator of the middle tier activates this facility by setting the new
“Suppress CHANGEPASSWORD View” attribute found on the NonStop ODBC driver
configuration page. This page is displayed whenever the ODBC Datasource
Administrator is invoked to add new datasource definitions or modify existing ones on
the middle-tier server.
Figure E-1. A Typical Three-Tier Configuration
CLIENT
Application calling
NonStop ODBC driver
on SERVER 1
SERVER
1
Application server,
NonStopODBC driver
manager,
NonStopODBC driver
SERVER 2
NonStop ODBC Server
data
VST048.vsd