Neoview ODBC Drivers Manual (R2.4)

Connections...........................................................................................................................................27
Connecting a Client to a Data Source..............................................................................................27
Associating a Connection with a WMS Service...............................................................................27
Object Naming and Mapping...............................................................................................................27
ANSI Name Type.............................................................................................................................27
Password Length.............................................................................................................................27
Password Expiration........................................................................................................................28
UCS2 Translation.............................................................................................................................28
Release Considerations and Restrictions..............................................................................................28
Pthreads and the HP-UX ODBC Driver................................................................................................29
Traces.....................................................................................................................................................29
Using the Driver With a Third Party Driver Manager..........................................................................29
Neoview Platform Specific Extensions and Attributes........................................................................30
Handling Larger Row Counts ........................................................................................................30
Specifying a Job ID or Session Name..............................................................................................30
Example......................................................................................................................................30
Specifying an Application Name.....................................................................................................31
Example......................................................................................................................................32
INFOSTATS Command ........................................................................................................................32
Example of INFOSTATS..................................................................................................................33
Unsupported ODBC API Functions and Data Types...........................................................................34
API Functions..................................................................................................................................34
Data Types.......................................................................................................................................34
Restricted ODBC API Functions......................................................................................................34
SQLBindParameter.....................................................................................................................34
SQLPutData................................................................................................................................34
3 Accessing Neoview SQL Data From Microsoft ODBC .NET Data Provider..........35
ODBC .NET Data Provider Classes......................................................................................................35
ODBC .NET Data Provider and the HP Neoview ODBC Driver.........................................................36
ODBC .NET Environment Setup..........................................................................................................37
Defining a Client Data Source...............................................................................................................37
Optimizing the HP Neoview ODBC Driver....................................................................................37
Sample Application Code Using ODBC .NET Data Provider..............................................................38
4 Configuring Client Data Sources................................................................................39
Adding New Client Data Sources.........................................................................................................39
Reconfiguring ODBC Client Data Sources...........................................................................................39
Configuring ODBC Client Data Sources for Update Operations.........................................................40
Removing ODBC Client Data Sources..................................................................................................40
Tracing Client Data Sources..................................................................................................................40
Configure Tracing on a Client Data Source.....................................................................................40
Start Tracing on a Client Data Source..............................................................................................40
Stop Tracing on a Client Data Source..............................................................................................41
Enabling Connection Pooling...............................................................................................................41
Configuring the Client Data Source on Linux, HP-UX, IBM AIX®, and Sun Solaris..........................42
Setting Trace On...............................................................................................................................42
Setting Trace Level...........................................................................................................................42
Adding a New Data Source.............................................................................................................43
Maximum Log File Size...................................................................................................................43
5 HP Neoview ODBC Drivers Conformance................................................................45
ODBC API Functions............................................................................................................................45
4 Table of Contents