Neoview ODBC Drivers Manual (R2.4)

The actual connection to be used is not determined by the Driver Manager until SQLConnect
or SQLDriverConnect is called.
4. Calls SQLConnect or SQLDriverConnect to make the connection. The Driver Manager uses
the connection options in the call to SQLConnect (or the connection keywords in the call to
SQLDriverConnect) and the connection attributes set after connection allocation to determine
which connection in the pool should be used.
NOTE: How a requested connection is matched to a pooled connection is determined by
the SQL_ATTR_CP_MATCH environment attribute.
5. Calls SQLDisconnect when done with the connection. The connection is returned to the
connection pool and becomes available for reuse.
For information on enabling connection pooling, see “Enabling Connection Pooling”.
Associating a Connection with a WMS Service
To control how queries are assigned to WMS service levels, the administrator uses WMS
commands to specify connection rules. These rules allow the mapping of queries to service levels
on the basis of one or more factors:
• The application name (APPL) in the connection request
• The session name (SESSION) in the connection request
• The client Login role (LOGIN)
• The client data source (DSN)
Thus, depending on the rules in effect for your Neoview platform, the values you assign to
SQL_ATTR_SESSIONNAME and SQL_ATTR_APPLNAME can determine the service level to
which your requests are assigned. For information about setting these values, see “Specifying a
Job ID or Session Name” (page 30) and “Specifying an Application Name” (page 31). For
information about WMS connection rules, see HP Neoview Workload Management Services Guide.
Object Naming and Mapping
ANSI Name Type
The HP Neoview ODBC driver supports only ANSI name types for database objects.
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 Length
The maximum password length allowed to connect to the Neoview database is 128 characters.
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:
16 HP Neoview ODBC Driver Overview for Windows