Neoview ODBC Drivers Manual (R2.3)

Data Sources
To configure ODBC client access to the Neoview database, NDCS requires data source definitions
on both the Neoview database and the client workstation.
Default Data Source
NDCS provides a preconfigured, default server data source on the server called
TDM_Default_DataSource. You can stop and start the TDM_Default_DataSource using HP
Neoview DB Admin, but you cannot delete it. The TDM_Default_DataSource has these functions:
• ODBC clients can connect to TDM_Default_DataSource.
• If an ODBC client tries to connect to a server data source that does not exist, it will default
to TDM_Default_DataSource. Contact your Administrator to create server data sources.
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.
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.
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.
Password Length
The maximum password length allowed to connect to the Neoview database is 64 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:
24 HP Neoview UNIX Drivers Overview