Neoview ODBC Drivers Manual (R2.5)

SQL_QUERY_TIMEOUT = SYSTEM_DEFAULT
If you specify the directory in multiple ways—for example, if you specify it at installation and
then specify a different value in the connection string:
1. The connection attribute has higher precedence than
2. The connection string, which has higher precedence than
3. The value specified during ODBC driver installation, or in the MXODSN or odbc.ini file
Similarly, if you specify the certificate filename in both a connection attribute and a connection
string, the connection attribute takes precedence.
Expired Certificates
When the workstation connects with a certificate that has expired, the ODBC driver:
1. Checks the location specified by SQL_ATTR_CERTIFICATE_DIR and
SQL_ATTR_CERTIFICATE_FILE (or the corresponding values in the connection string
or—in the case of the certificate directory—in the ODBC driver installation, MXODSN or
odbc.ini file) to determine whether a certificate exists at that location. If the application did
not specify a directory, the driver checks the user's home directory. If the application did
not specify a filename, the driver assumes the name SYSTEM_NAME.cer, where
SYSTEM_NAME consists of the first five characters of the Neoview platform name.
2. If no certificate for the Neoview platform exists at the expected location and if automatic
download is permitted, the driver downloads the certificate from the Neoview platform to
the location specified by SQL_ATTR_CERTIFICATE_ACTIVE. If the application did not
specify that attribute, the driver assumes the name SYSTEM_NAMEActive.cer, where
SYSTEM_NAME consists of the first five characters of the Neoview platform name. If automatic
download is prohibited, an error occurs.
For detailed information about security certificates on your workstation, see the Neoview User
Management and Security Administration Guide.
Release Considerations and Restrictions
Table 2-1 Release Considerations and Restrictions for HP Neoview ODBC Drivers for UNIX
If your application relies on a standard driver manager
to load the HP ODBC library, the library, libhpodbc_drvr,
should be used. Refer to your standard driver manager
documentation for information on how to configure an
ODBC library with libhpodbc_drvr.
The library, libhpodbc, which provides the functionality
of the driver manager and driver, is not suitable for
loading from another driver manager.
HP ODBC driver software
An ODBC client application can set the schema for an
ODBC client data source by editing your MXODSN file.
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.
Schema
This function does not support pattern value arguments
for table names, and returns keys information for a
specified table name.
SQLPrimaryKeys Function
This function does not support pattern value arguments
for table names, and returns an optimal set of columns
that uniquely identifies a row in the table information for
a specified table name.
SQLSpecialColumns Function
38 HP Neoview ODBC Drivers Overview for UNIX