Neoview ODBC Drivers Manual (R2.4)

• Provide the old and new passwords in a dialog box that displays with the expiration warning.
If you enter an invalid password, the connection is terminated.
You can also cancel the password change and just continue with the current session.
• Provide the old and new passwords in the connection string:
PWD=old_password, new_password, new_password
You can enable the password expiration notification feature, which sends a warning message to
the driver when a password is scheduled to expire in the next two days or a password has already
expired but is still within the grace period.
To enable notification of password expiration:
1. Using DB Admin, set the SQL_ATTR_WARNING enviroment variable in the SET tab to 1.
(The default value of SQL_ATTR_WARNING is 0 (disabled).)
This setting directs SQLConnect, SQLBrowseConnect and SQLDriverConnect to return
SQL_SUCCESS_WITH_INFO withone of these warnings:
• [WARNING 8857] Password to Expire in n days, n hours, n minutes. (If the password
expires in less than two days.)
OR
• [WARNING 8837] CLI Authorization failure: Error 48 with status 11 was returned by
Safecom. (If the password is expired and within the grace period.)
2. If the application uses SQLDriverConnect with the SQL_DRIVER_PROMPT attribute, the
ODBC driver prompts your to change the password.
You have these options:
• Cancel the password change and proceed with the current session.
• Change the password by providing the old and new passwords. If an invalid password
is entered. the connection is terminated.
If the password is already expired but within the grace period, and you elect not to change
the password, the connection is terminated.
Release Considerations and Restrictions
Table 1-1 Release Considerations and Restrictions for Windows Driver
HP Neoview ODBC driver requires the Microsoft ODBC
3.51 (or later) driver manager. If you do not already have
the 3.51 driver manager, the HP Neoview ODBC driver
installs it for you.
ODBC driver manager
An HP Neoview ODBC driver can coexist with other
ODBC drivers.
HP Neoview ODBC client software
An ODBC client application can set the schema for an
ODBC client data source by using the HP Neoview ODBC
Driver window in the Microsoft ODBC Administrator. If
an ODBC client does not set the schema for an ODBC
client data source, NDCS defaults to USR. Note:
• Schema names follow SQL rules and are case sensitive.
• Schema names that are defined by default are not
recognized by NDCS for client data sources because
they are not defined through the Microsoft ODBC
Administrator. You must either define the catalog and
schema names using the Microsoft ODBC
Administrator, or use the fully qualified object name.
Schema
Release Considerations and Restrictions 17