Neoview ODBC Drivers Manual (R2.2 SP1)

Driver components can be installed on any workstation running Linux, HP-UX, or IBM AIX®.
These are the client components:
Text file that contains client data sources.MXODSN file
Run the sample program to verify a connection for HP
Neoview ODBC Linux, HP-UX (32 and 64–bit), and IBM
AIX® drivers.
Sample program
Is 3.0 compliant and implements a subset of the ODBC
3.51 APIs. Enables an ODBC client application to access
the Neoview database.
HP Neoview ODBC driver
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
24 HP Neoview ODBC Drivers Overview for Linux, HP-UX, IBM AIX®, and Sun Solaris