Neoview ODBC Drivers Manual (R2.2)

Using the Microsoft OBDC Administrator at a client workstation, you can configure the default
schema name used to qualify the table names in queries.
The object name format is as follows:
schema.object-name
ANSI names have a maximum of 128 characters for each part of the name (not including the
dots).
Ensure the catalog name is not qualified while defining your schema.
Password Expiration
NDCS is configured to allow the driver to display password expiration warnings. You can change
your password during the current session in one of two ways:
• 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
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.
See “Installing ODBC Client Software”for more
information.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
An ODBC application can call SQLSetStmtOption with
the SQL_QUERY_TIMEOUT option to specify the number
of seconds to wait for a query to execute. The
SQL_QUERY_TIMEOUT option protects the NDCS server
and ODBC client from long running queries. If a query
exceeds the specified time before the data source returns
the result set, the HP Neoview ODBC driver returns
HYT00 (Timeout expired) to the ODBC client.
SQL_QUERY_TIMEOUT Option
18 HP Neoview ODBC Driver Overview for Windows