Neoview ODBC Drivers Manual (R2.5)

Table of Contents
About This Document.........................................................................................................9
Intended Audience.................................................................................................................................9
New and Changed Information in This Edition.....................................................................................9
Document Organization.........................................................................................................................9
Notation Conventions...........................................................................................................................10
General Syntax Notation.................................................................................................................10
Related Documentation........................................................................................................................11
Neoview Customer Library.............................................................................................................12
Publishing History................................................................................................................................13
HP Encourages Your Comments..........................................................................................................14
1 HP Neoview ODBC Driver Overview for Windows.................................................15
Driver Components..............................................................................................................................15
Drivers Supported.................................................................................................................................15
Data Sources..........................................................................................................................................16
Default Data Source.........................................................................................................................16
Client Data Sources..........................................................................................................................16
Connections...........................................................................................................................................16
Connecting a Client to a Data Source..............................................................................................16
Connection Pooling.........................................................................................................................16
Associating a Connection with a WMS Service...............................................................................18
Object Naming and Mapping...............................................................................................................18
ANSI Name Type.............................................................................................................................18
Passwords and Server Certificates........................................................................................................18
Password Handling Changes for Release 2.5..................................................................................19
Password Length.............................................................................................................................19
Password Expiration........................................................................................................................19
Password Encryption.......................................................................................................................19
Passwords for Platform-level Users................................................................................................19
Passwords for Database (LDAP) Users...........................................................................................20
Use of Braces in Passwords.............................................................................................................20
Secure Login and Multiple-Role Support for Neoview ODBC Drivers..........................................21
Logging On as a Database User.................................................................................................21
Logging on as a Platform User...................................................................................................21
Server Certificates............................................................................................................................21
Specifying the Certificate File Location .....................................................................................22
Expired Certificates....................................................................................................................22
Release Considerations and Restrictions..............................................................................................23
SQLCancel Function........................................................................................................................24
Traces.....................................................................................................................................................24
Neoview Platform Specific Extensions and Attributes........................................................................25
Handling Larger Row Counts ........................................................................................................25
Specifying a Job ID or Session Name..............................................................................................25
Example......................................................................................................................................25
Specifying an Application Name.....................................................................................................26
Examples....................................................................................................................................26
Network I/O Compression..............................................................................................................27
INFOSTATS Command ........................................................................................................................27
Example of INFOSTATS..................................................................................................................28
Unsupported ODBC API Functions and Data Types...........................................................................29
Table of Contents 3