HP Integrity NonStop H-Series - Manual (Page 3)

Contents
About this document......................................................................................5
Intended audience....................................................................................................................5
Document organization.............................................................................................................5
New and changed information in this edition...............................................................................5
Notation conventions................................................................................................................5
General syntax notation........................................................................................................5
Related Documentation..............................................................................................................7
NonStop SQL/MX customer library........................................................................................7
Publishing history......................................................................................................................9
HP encourages your comments...................................................................................................9
1 Overview................................................................................................10
Architecture...........................................................................................................................10
Client components..................................................................................................................12
Server components.................................................................................................................12
Driver managers.....................................................................................................................12
Data sources..........................................................................................................................13
Client data source configuration...........................................................................................13
Server data source configuration..........................................................................................13
Default data source............................................................................................................13
Tracing..................................................................................................................................14
Object naming and mapping...................................................................................................14
ANSI name type................................................................................................................14
ANSI names for SQL/MX objects.........................................................................................14
ANSI alias names for SQL/MP objects.................................................................................14
Unsupported ODBC APIs.........................................................................................................14
Unsupported ODBC data types................................................................................................15
Considerations and limitations..................................................................................................15
2 Installing the drivers..................................................................................17
Installation requirements..........................................................................................................17
Installation procedures.............................................................................................................17
Verifying the installation..........................................................................................................21
Uninstalling the driver.............................................................................................................22
3 Configuring data sources...........................................................................24
Configuring a client data source...............................................................................................24
Configuring the drivers for IPv6................................................................................................26
Configuring a secure ODBC connection using NonStop SSL.........................................................26
Installing a NonStop SSL Server process for ODBC/MX..........................................................26
Installing and configuring the Remote Proxy Client..................................................................27
Configuring a client data source for NonStop SSL..................................................................28
DataSource configuration in Windows driver..............................................................................29
MXODSN and ODBCDSN file formats......................................................................................30
Managing data sources..........................................................................................................33
Managing transactions............................................................................................................34
Setting AutoCommit...........................................................................................................34
Tracing..................................................................................................................................35
4 Compatibility and considerations...............................................................37
Considerations.......................................................................................................................37
ODBC data types...................................................................................................................38
Unsigned data types...............................................................................................................39
Contents 3