Neoview ODBC Drivers Manual (R2.5)

Unicode C and SQL Data Types...........................................................................................................48
Unicode Driver Behavior......................................................................................................................48
4 HP Neoview Unicode Driver for UNIX.......................................................................51
Unicode APIs........................................................................................................................................51
Unicode C and SQL Data Types...........................................................................................................51
Unicode Driver Behavior......................................................................................................................52
5 Accessing Neoview SQL Data From Microsoft ODBC .NET Data Provider..........53
ODBC .NET Data Provider Classes......................................................................................................53
ODBC .NET Data Provider and the HP Neoview ODBC Driver.........................................................54
ODBC .NET Environment Setup..........................................................................................................55
Defining a Client Data Source...............................................................................................................55
Optimizing the HP Neoview ODBC Driver....................................................................................55
Sample Application Code Using ODBC .NET Data Provider..............................................................56
6 Configuring Client Data Sources................................................................................57
Adding New Client Data Sources.........................................................................................................57
Reconfiguring ODBC Client Data Sources...........................................................................................57
Configuring ODBC Client Data Sources for Update Operations.........................................................58
Removing ODBC Client Data Sources..................................................................................................58
Tracing Client Data Sources..................................................................................................................58
Configure Tracing on a Client Data Source.....................................................................................58
Start Tracing on a Client Data Source..............................................................................................58
Stop Tracing on a Client Data Source..............................................................................................59
Enabling Connection Pooling...............................................................................................................59
Configuring the Client Data Source on Linux, HP-UX, IBM AIX®, and Sun Solaris..........................60
Setting Trace On...............................................................................................................................60
Setting Trace Level...........................................................................................................................60
Adding a New Data Source.............................................................................................................61
Maximum Log File Size...................................................................................................................61
7 HP Neoview ODBC Drivers Conformance................................................................63
ODBC API Functions............................................................................................................................63
SQL Conformance Level.......................................................................................................................68
SQL Scalar Functions.......................................................................................................................68
CONVERT Function...................................................................................................................70
ODBC Data Types............................................................................................................................70
Extended Numeric Precision Columns......................................................................................72
Unsigned Data Types.......................................................................................................................72
Partial Date/Time Values.................................................................................................................72
Microsoft Escape Clauses................................................................................................................72
Stored Procedures............................................................................................................................72
Transactions and Cursor Behavior with Multiple Statements........................................................73
8 HP Neoview ODBC Drivers Messages......................................................................75
HP Neoview ODBC Drivers Error Codes.............................................................................................75
HP Neoview ODBC Client Messages..............................................................................................75
Password and Certificate Related Error Messages...............................................................................78
Password Encryption Errors Passed to ODBC Applications..........................................................78
Connectivity Service Error Messages .............................................................................................80
Table of Contents 5