Neoview ODBC Drivers Manual (R2.5)

shared environment is found, the environment is returned to the application, and its reference
count is incremented.
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 an
Application Name” (page 41) and “Specifying an Application Name” (page 26). 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.
Passwords and Server Certificates
As of release 2.5, Neoview ODBC Drivers have these changes to support new security, password,
and server certificate features:
• Connection attributes for specifying the location of the server certificate used to encrypt
passwords when connecting to a specific Neoview platform from the workstation
• Connection attribute for specifying the role during logon
18 HP Neoview ODBC Driver Overview for Windows