Neoview ODBC Drivers Manual (R2.5)

Client Data Sources
Client data sources reside on a client workstation. Each client data source is a logical name that
identifies the attribute values used to connect to NDCS.
Edit your data source configuration file (MXODSN) to add a new data source or change the data
source configuration.
NOTE: If an ODBC client tries to connect to a server data source that is stopped, NDCS rejects
the connection.
Setting the Client Character Set
For UNIX ODBC Drivers, the default client character set is ISO88591. You can set it to something
else in the MXODSN file by specifying a different value for ClientCharSet.
For a list of acceptable values see http://www.iana.org/assignments/character-sets.
Connections
Connecting a Client to a Data Source
The following scenario describes how an ODBC client application connects to NDCS:
1. The ODBC client application connects using the client data source name. The client source
data specifies an IP address or host name and port number.
2. If the user information is not valid, the connection is rejected.
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 40) and “Specifying an Application Name” (page 41). For
information about WMS connection rules, see HP Neoview Workload Management Services Guide.
Object Naming and Mapping
ANSI Name Type
The HP Neoview ODBC drivers support only ANSI name types for database objects.
Use your MXODSN file to configure the default schema name used to qualify the table names
in queries.
The 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.
Connections 33