README for the HP Neoview UNIX Drivers (Upd6 R2.2)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.2 Software

README for the HP Neoview UNIX Drivers

(R2.2.6)

HP Part Number: 588678-001

Published: August 2009

Summary of content (64 pages)

PAGE 1
README for the HP Neoview UNIX Drivers (R2.2.
PAGE 2
© Copyright 2009 Hewlett-Packard Development Company, L.P. Legal Notice The computer program listings, specifications, and documentation herein are the property of Hewlett-Packard Development Company, L.P. or a third-party supplier and shall not be reproduced, copied, disclosed, or used in whole or in part for any reason without the prior express written permission of Hewlett-Packard Development Company, L.P.
PAGE 3
Table of Contents .................................................................................................................................................................5 What's New............................................................................................................................................5 Features in Neoview Release 2.3 Update 1......................................................................................5 Features in Neoview Release 2.3....................
PAGE 4
Installation for Neoview Release 2.2 Update 2...................................................................................40 Installation Package........................................................................................................................41 Installation Instructions.................................................................................................................43 Installing or Reinstalling the HP Neoview UNIX Drivers...........................................
PAGE 5
The HP Neoview UNIX drivers are based on the Microsoft Open Database Connectivity (ODBC) standard. These ODBC drivers enable ODBC clients to access the HP Neoview platform from HP-UX, Linux, IBM AIX®, or Sun Solaris for SPARC® based systems. Connectivity is restricted to the HP Neoview platform, which is an enterprise data warehouse for business intelligence. What's New Features in Neoview Release 2.3 Update 1 This version of the driver includes defect repairs. Features in Neoview Release 2.
PAGE 6
Features in Neoview Release 2.0 This version of the driver offers these new features: • • • • Support for the INFOSTATS command in ODBC client applications. INFOSTATS collects statistics for a prepared statement. The driver can now display password expiration warnings, and you can change your password during the current session. You can use the driver with a third-party driver manager.
PAGE 7
For information about avoiding driver and Neoview platform version incompatibility, see the HP Neoview ODBC Drivers Manual at docs.hp.com: http://docs.hp.com/en/busintellsol.html. Getting the Version of the Driver 1. Move to the directory where you installed the library file of the HP Neoview ODBC driver: cd is the directory where you installed the library file of the HP Neoview ODBC driver. For details, see the installation instructions.
PAGE 8
2. Retrieve the version string: • On Linux: nm libhpodbc.so | grep HPODBC or nm libhpodbc_drvr.so | grep HPODBC • On x86_64 Linux: nm libhpodbc64.so | grep HPODBC or nm libhpodbc_drvr64.so | grep HPODBC • On IA–64 Linux: nm libhpodbc.so | grep HPODBC or nm libhpodbc_drvr.so | grep HPODBC • On HP-UX (IA-64) and HP-UX (PA-RISC): nm libhpodbc.sl | grep HPODBC or nm libhpodbc_drvr.sl | grep HPODBC • On HP-UX (IA-64) 64 bit and HP-UX (PA-RISC) 64 bit: nm libhpodbc64.
PAGE 9
Installation Package The HP Neoview UNIX driver software is available in these downloadable distribution files: Distribution File Supported Platform File Contents hpodbc__Linux_pkg.tar.gz Linux libhpodbc_l.so. libhpodbc_drvr_l.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__Linux64_pkg.tar.gz x86_64 Linux libhpodbc_l64.so. libhpodbc_drvr_l64.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.
PAGE 10
Distribution File Supported Platform File Contents hpodbc__HPUX_P_64_pkg.tar.gz HP-UX PA-RISC 64 bit libhpodbc_p64.sl. libhpodbc_drvr_p64.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a..gcc libhpodbc.a..xlc libhpodbc_drvr.a..gcc libhpodbc_drvr.a..xlc MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__AIX64_pkg.tar.
PAGE 11
Note: For the HPUX (PA-RISC) 64 bit driver, the default lib location is /usr/lib/pa20_64. • • • /usr/include/hpodbc /etc/hpodbc /etc/hpodbc/sample Installation Instructions Installing or Reinstalling the HP Neoview UNIX Drivers Note: You must have root access to install the HP Neoview UNIX drivers at the default system locations. 1. 2. 3. 4. 5. 6. Create a temporary directory. From the client workstation, start a browser and navigate to the download site: www.software.hp.com.
PAGE 12
• • • • • 9. HP-UX (PA-RISC) 64 bit: tar –xvf hpodbc__HPUX_P_64_pkg.tar.gz IBM AIX®: tar –xvf hpodbc__AIX_pkg.tar IBM AIX® 64 bit: tar –xvf hpodbc__AIX64_pkg.tar Sun SPARC®: tar –xvf hpodbc__SPARC_pkg.tar Sun SPARC® 64 bit: tar –xvf hpodbc__SPARC64_pkg.tar Install the product: cd PkgTmp ./install.sh Note: Except for the sample file, the install.sh script saves a copy (.SAV) of your previous installation files if they exist. 10.
PAGE 13
• The three environment variables that control tracing are: — HPODBC_TRACE_LEVEL — sets trace level (ERROR, WARNING, CONFIG, INFO, or DEBUG) — HPODBC_TRACEFILE_NAME — specifies the name of the log file — HPODBC_TRACEFILE_SIZE — specifies the maximum files size of the log files • For information on the necessary data source configuration options, you will need to add to the respective configuration files (for example, to odbc.ini). For more information, see the Neoview ODBC Drivers Manual at docs.hp.
PAGE 14
To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c Run this command: cc connect_test.c +DD64 –I/usr/include/hpodbc -L/usr/lib/hpux64 \ –lhpodbc64 –lstd_v2 -lCsup -lunwind -lm -lhpodbc -o connect_test Note: Multi-threaded applications should use the “-mt” compiler option. Non multi-threaded applications that use ODBC asynchronous execution should ensure that the pthread library is linked in and it is linked in ahead of the libc library.
PAGE 15
• On Sun SPARC®: cc connect_test.cpp -I/usr/include/hpodbc -L/usr/lib \ -lhpodbc -o connect_test • On Sun SPARC® 64 bit: cc -xarch=v9a connect_test.cpp -I/usr/include/hpodbc -L/usr/lib \ -lhpodbc64 -o connect_test 3. 4. If needed, modify the /etc/hpodbc/MXODSN file. Run the sample program: ./connect_test -d -u -p Installation for Neoview Release 2.
PAGE 16
Distribution File 16 Supported Platform File Contents hpodbc__HPUX_I_64_pkg.tar.gz HP-UX (IA-64) 64 bit libhpodbc_i64.sl. libhpodbc_i64_drvr.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpodbcext.h install.h connect_test.cpp hpodbc__HPUX_P_pkg.tar.gz HP-UX PA-RISC libhpodbc_p.sl. libhpodbc_drvr_p.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpodbcext.h install.h connect_test.cpp hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a. libhpodbc_drvr.a.
PAGE 17
By default, a new version of the HP Neoview ODBC driver is installed in these directories unless you specify different directories during installation: • /usr/lib Note: For the HPUX (IA-64) 64 bit driver, the default lib location is /usr/lib/hpux64. • • • /usr/include/hpodbc /etc/hpodbc /etc/hpodbc/sample Installation Instructions Installing or Reinstalling the HP Neoview UNIX Drivers Note: You must have root access to install the HP Neoview UNIX drivers at the default system locations. 1. 2. 3. 4. 5.
PAGE 18
• • • • 9. IBM AIX®: tar –xvf hpodbc__AIX_pkg.tar IBM AIX® 64 bit: tar –xvf hpodbc__AIX64_pkg.tar Sun SPARC®: tar –xvf hpodbc__SPARC_pkg.tar Sun SPARC® 64 bit: tar –xvf hpodbc__SPARC64_pkg.tar Install the product: cd PkgTmp ./install.sh Note: Except for the sample file, the install.sh script saves a copy (.SAV) of your previous installation files if they exist. 10. Accept the terms of the license agreement. 11.
PAGE 19
• The three environment variables that control tracing are: — HPODBC_TRACE_LEVEL — sets trace level (ERROR, WARNING, CONFIG, INFO, or DEBUG) — HPODBC_TRACEFILE_NAME — specifies the name of the log file — HPODBC_TRACEFILE_SIZE — specifies the maximum files size of the log files • For information on the necessary data source configuration options, you will need to add to the respective configuration files (for example, to odbc.ini). For more information, see the Neoview ODBC Drivers Manual at docs.hp.
PAGE 20
To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c Run this command: cc connect_test.c +DD64 –I/usr/include/hpodbc -L/usr/lib/hpux64 \ –lhpodbc64 –lstd_v2 -lCsup -lunwind -lm -lhpodbc -o connect_test Note: When linking in the pthread library, it should be linked in ahead of –lhpodbc. • On HP-UX (PA-RISC): aCC -AA connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc -lhppa -o connect_test -lm To use cc for compiling and linking: — — Rename connect_test.
PAGE 21
Installation Package The HP Neoview UNIX driver software is available in these downloadable distribution files: Distribution File Supported Platform File Contents hpodbc__Linux_pkg.tar.gz Linux libhpodbc_l.so. libhpodbc_drvr_l.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__Linux64_pkg.tar.gz x86_64 Linux libhpodbc_l64.so. libhpodbc_drvr_l64.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.
PAGE 22
Distribution File Supported Platform File Contents hpodbc__HPUX_P_pkg.tar.gz HP-UX PA-RISC libhpodbc_p.sl. libhpodbc_drvr_p.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__HPUX_P_64_pkg.tar.gz HP-UX PA-RISC 64 bit libhpodbc_p64.sl. libhpodbc_drvr_p64.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp 22 hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a..gcc libhpodbc.a..
PAGE 23
Distribution File Supported Platform File Contents hpodbc__SPARC_pkg.tar.gz Sun SPARC® libhpodbc_ss.so. libhpodbc_drvr_ss.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__SPARC64_pkg.tar.gz Sun SPARC® 64 bit libhpodbc_ss64.so. libhpodbc_drvr_ss64.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.
PAGE 24
• • • • • HP-UX (PA-RISC) 64 bit: hpodbc__HPUX_P_64_pkg.tar.gz IBM AIX®: hpodbc__AIX_pkg.tar.gz IBM AIX® 64 bit: hpodbc__AIX64_pkg.tar.gz Sun SPARC®: hpodbc__SPARC_pkg.tar.gz Sun SPARC® 64 bit: hpodbc__SPARC64_pkg.tar.gz 7. Expand the installation and product files: • Linux: gunzip hpodbc__LINUX_pkg.tar.gz • x86_64 Linux: gunzip hpodbc__LINUX64_pkg.tar.gz • IA-64 Linux: gunzip hpodbc__LINUXIA64_pkg.tar.
PAGE 25
Setting Up the Client Environment If you selected default options during installation, ensure that: • The include (*.h) files are in the /usr/include/hpodbc directory. • An MXODSN file is in the /etc/hpodbc directory. Note: By default, the MXODSN file in the package will be installed as /etc/hpodbc/MXODSN.template. Rename it to MXODSN, and make necessary changes to the file before using the driver. • The libraries are located in the /usr/lib directory.
PAGE 26
Note: The Linux driver is a 32-bit driver. If you are using an x86–64 machine, you need to explicitly compile your appplication as a 32-bit application. For example: g++ connect_test.cpp -m32 -L/usr/lib \ -I/usr/include/hpodbc -lhpodbc -o connect_test • On x86_64 Linux: g++ connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc64 -o connect_test • On IA–64 Linux: g++ connect_test.
PAGE 27
To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c. Run this command: cc connect_test.c –L/usr/lib –I/usr/include/hpodbc \ -lhppa -lstd_v2 -lCsup_v2 -lm -lhpodbc -o connect_test Note: Multi-threaded applications should use the “-mt” compiler option. Non multi-threaded applications that use ODBC asynchronous execution should ensure that the pthread library is linked in and it is linked in ahead of the libc library. • On HP-UX (PA-RISC) 64 bit: aCC +DD64 -AA connect_test.
PAGE 28
Installation for Neoview Release 2.2 Update 4 • • Installation Package Installation Instructions Installation Package The HP Neoview UNIX driver software is available in these downloadable distribution files: 28 Distribution File Supported Platform File Contents hpodbc__Linux_pkg.tar.gz Linux libhpodbc_l.so. libhpodbc_drvr_l.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__Linux64_pkg.tar.gz x86_64 Linux libhpodbc_l64.so.
PAGE 29
Distribution File Supported Platform File Contents hpodbc__HPUX_P_64_pkg.tar.gz HP-UX PA-RISC 64 bit libhpodbc_p64.sl. libhpodbc_drvr_p64.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a..gcc libhpodbc.a..xlc libhpodbc_drvr.a..gcc libhpodbc_drvr.a..xlc MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h hpsqlext.h connect_test.cpp hpodbc__AIX64_pkg.tar.
PAGE 30
Note: For the HP-UX (PA-RISC) 64 bit driver, the default lib location is /usr/lib/pa20_64. • • • /usr/include/hpodbc /etc/hpodbc /etc/hpodbc/sample Installation Instructions Installing or Reinstalling the HP Neoview UNIX Drivers Note: You must have root access to install the HP Neoview UNIX drivers at the default system locations. 1. 2. 3. 4. 5. 6. 30 Create a temporary directory. From the client workstation, start a browser and navigate to the download site: www.software.hp.com.
PAGE 31
• • • • • 9. HP-UX (PA-RISC) 64 bit: tar –xvf hpodbc__HPUX_P_64_pkg.tar IBM AIX®: tar –xvf hpodbc__AIX_pkg.tar IBM AIX® 64 bit: tar –xvf hpodbc__AIX64_pkg.tar Sun SPARC®: tar –xvf hpodbc__SPARC_pkg.tar Sun SPARC® 64 bit: tar –xvf hpodbc__SPARC64_pkg.tar Install the product: cd PkgTmp ./install.sh Note: Except for the sample file, the install.sh script saves a copy (.SAV) of your previous installation files if they exist. 10.
PAGE 32
• The three environment variables that control tracing are: — HPODBC_TRACE_LEVEL — sets trace level (ERROR, WARNING, CONFIG, INFO, or DEBUG) — HPODBC_TRACEFILE_NAME — specifies the name of the log file — HPODBC_TRACEFILE_SIZE — specifies the maximum files size of the log files • For information on the necessary data source configuration options, you will need to add to the respective configuration files (for example, to odbc.ini). For more information, see the Neoview ODBC Drivers Manual at docs.hp.
PAGE 33
To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c Run this command: cc connect_test.c +DD64 –I/usr/include/hpodbc -L/usr/lib/hpux64 \ -lhpodbc64 -lstd_v2 -lCsup -lunwind -lm -lhpodbc -o connect_test Note: Multi-threaded applications should use the “-mt” compiler option. Non multi-threaded applications that use ODBC asynchronous execution should ensure that the pthread library is linked in and it is linked in ahead of the libc library.
PAGE 34
• On Sun SPARC®: CC connect_test.cpp -I/usr/include/hpodbc -L/usr/lib \ -lhpodbc -o connect_test • On Sun SPARC®: 64 bit CC -xarch=v9a connect_test.cpp -L/usr/lib -I/usr/include/hpodbc —L/usr/lib \ -lhpodbc64 -o connect_test 3. 4. If needed, modify the /etc/hpodbc/MXODSN file. Run the sample program: ./connect_test -d -u -p Installation for Neoview Release 2.
PAGE 35
Distribution File Supported Platform File Contents hpodbc__HPUX_I_64_pkg.tar.gz HP-UX (IA-64) 64 bit libhpodbc_i64.sl. libhpodbc_i64_drvr.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__HPUX_P_pkg.tar.gz HP-UX PA-RISC libhpodbc_p.sl. libhpodbc_drvr_p.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__HPUX_P_64_pkg.tar.gz HP-UX PA-RISC 64 bit libhpodbc_p64.sl.
PAGE 36
Distribution File Supported Platform File Contents hpodbc__SPARC_pkg.tar.gz Sun SPARC® libhpodbc_ss.so. libhpodbc_drvr_ss.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__SPARC64_pkg.tar.gz Sun SPARC® 64 bit libhpodbc_ss64.so. libhpodbc_drvr_ss64.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.
PAGE 37
• • • • IBM AIX®: hpodbc__AIX_pkg.tar.gz IBM AIX® 64 bit: hpodbc__AIX64_pkg.tar.gz Sun SPARC®: hpodbc__SPARC_pkg.tar.gz Sun SPARC® 64 bit: hpodbc__SPARC64_pkg.tar.gz 7. Expand the installation and product files: • Linux: gunzip hpodbc__LINUX_pkg.tar.gz • x86_64 Linux: gunzip hpodbc__LINUX64_pkg.tar.gz • HP-UX (IA-64): gunzip hpodbc__HPUX_I_pkg.tar.gz • HP-UX (IA-64) 64 bit: gunzip hpodbc__HPUX_I_64_pkg.tar.
PAGE 38
• • The include (*.h) files are in the /usr/include/hpodbc directory. An MXODSN file is in the /etc/hpodbc directory. Note: By default, the MXODSN file in the package will be installed as /etc/hpodbc/MXODSN.template. Rename it to MXODSN, and make necessary changes to the file before using the driver. • The libraries are located in the /usr/lib directory. Note: For the HPUX (IA-64) 64 bit driver, the default lib location is /usr/lib/hpux64.
PAGE 39
gcc connect_test.cpp -m32 -L/usr/lib \ -I/usr/include/hpodbc -lhpodbc -o connect_test • On x86_64 Linux: gcc connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc64 -o connect_test • On HP-UX (IA-64): aCC -AA connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc -o connect_test -lm To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c. Run this command: cc connect_test.
PAGE 40
To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c. Run this command: cc +DD64 connect_test.c –L/usr/lib/pa20_64 –I/usr/include/hpodbc \ -lstd_v2 -lCsup_v2 –lcl lm -lhpodbc64 -o connect_test Note: Multi-threaded applications should use the “-mt” compiler option. Non multi-threaded applications that use ODBC asynchronous execution should ensure that the pthread library is linked in and it is linked in ahead of the libc library. • On IBM AIX®: g++ -maix32 connect_test.
PAGE 41
Installation Package The HP Neoview UNIX driver software is available in these downloadable distribution files: Distribution File Supported Platform File Contents hpodbc__Linux_pkg.tar.gz Linux libhpodbc_l.so. libhpodbc_drvr_l.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__Linux64_pkg.tar.gz x86_64 Linux libhpodbc_l64.so. libhpodbc_drvr_l64.so. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.
PAGE 42
Distribution File Supported Platform File Contents hpodbc__HPUX_P_64_pkg.tar.gz HP-UX PA-RISC 64 bit libhpodbc_p64.sl. libhpodbc_p64_drvr_p.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h hpsqlext.h install.h connect_test.cpp hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a. libhpodbc_drvr.a. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h hpsqlext.h connect_test.cpp hpodbc__AIX64_pkg.tar.gz IBM AIX® 64 bit libhpodbc64.a. libhpodbc64_drvr.a. MXODSN MD5SUM sql.h sqlext.
PAGE 43
Installation Instructions Installing or Reinstalling the HP Neoview UNIX Drivers Note: You must have root access to install the HP Neoview UNIX drivers at the default system locations. 1. 2. 3. 4. 5. 6. Create a temporary directory. From the client workstation, start a browser and navigate to the download site: www.software.hp.com. Search for “Neoview ODBC” in the Software Depot. Click the HP Neoview ODBC HP-UX LINUX Driver link that appears in the search results.
PAGE 44
9. Install the product: cd PkgTmp ./install.sh Note: Except for the sample file, the install.sh script saves a copy (.SAV) of your previous installation files if they exist. 10. Accept the terms of the license agreement. 11. Enter a directory for the library files, or press Enter to use the default directory (/usr/lib). Note: For the HP-UX (IA-64) 64 bit driver, the default lib location is /usr/lib/hpux64. Note: For the HP-UX (PA-RISC) 64 bit driver, the default lib location is /usr/lib/pa20_64.
PAGE 45
• The three environment variables that control tracing are: — HPODBC_TRACE_LEVEL — sets trace level (ERROR, WARNING, CONFIG, INFO, or DEBUG) — HPODBC_TRACEFILE_NAME — specifies the name of the log file — HPODBC_TRACEFILE_SIZE — specifies the maximum files size of the log files • For information on the necessary data source configuration options, you will need to add to the respective configuration files (for example, to odbc.ini). For more information, see the Neoview ODBC Drivers Manual at docs.hp.
PAGE 46
To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c Run this command: cc connect_test.c +DD64 –I/usr/include/hpodbc -L/usr/lib/hpux64 \ -lhpodbc64 -lstd_v2 -lCsup -lunwind -lm -lhpodbc -o connect_test Note: when linking in the pthread library, it should be linked in ahead of -lhpodbc64 • On HP-UX (PA-RISC): aCC -AA connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc -lhppa -o connect_test -lm To use cc for compiling and linking: — — Rename connect_test.
PAGE 47
-lhpodbc -o connect_test • On Sun SPARC®: 64 bit CC -xarch=v9a connect_test.cpp -L/usr/lib -I/usr/include/hpodbc —L/usr/lib \ -lhpodbc64 -o connect_test 3. 4. If needed, modify the /etc/hpodbc/MXODSN file. Run the sample program: ./connect_test -d -u -p Installation for Neoview Release 2.
PAGE 48
Distribution File Supported Platform File Contents hpodbc__HPUX_P_pkg.tar.gz HP-UX PA-RISC libhpodbc_p.sl. libhpodbc_drvr_p.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.cpp hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a. libhpodbc_drvr.a. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.cpp hpodbc__AIX64_pkg.tar.gz IBM AIX® 64 bit libhpodbc64.a. libhpodbc64_drvr.a. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.
PAGE 49
1. 2. 3. 4. 5. 6. Create a temporary directory. From the client workstation, start a browser and navigate to the download site: www.software.hp.com. Search for “Neoview ODBC” in the Software Depot. Click the HP Neoview ODBC HP-UX LINUX Driver link that appears in the search results.
PAGE 50
13. Enter a directory for the include files, or press Enter to use the default directory (/usr/include/hpodbc). 14. Enter a directory for the sample program, or press Enter to use the default directory (/etc/hpodbc/sample). Setting Up the Client Environment If you selected default options during installation, ensure that: • The include (*.h) files are in the /usr/include/hpodbc directory. • An MXODSN file is in the /etc/hpodbc directory.
PAGE 51
2. Compile the sample program. Note: All drivers, other than the 64–bit driver for HP-UX(IA-64) and the x86_64 Linux driver, are 32-bit drivers; therefore, applications need to be compiled accordingly. • On Linux: gcc connect_test.cpp -L/usr/lib -I/usr/include/hpodbc -lhpodbc \ -o connect_test Note: The Linux driver is a 32-bit driver. If you are using an x86–64 machine, you need to explicitly compile your appplication as a 32-bit application. For example: gcc connect_test.
PAGE 52
-lhpodbc64 -o connect_test • On Sun SPARC®: g++ -m32 connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc -o connect_test • On Sun SPARC®: 64 bit g++ -m64 connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc64 -o connect_test 3. 4. If needed, modify the /etc/hpodbc/MXODSN file. Run the sample program: ./connect_test -d -u -p Installation for Neoview Release 2.
PAGE 53
Distribution File Supported Platform File Contents hpodbc__HPUX_I_64_pkg.tar.gz HP-UX (IA-64) 64 bit libhpodbc_i64.sl. libhpodbc_i64_drvr.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.cpp hpodbc__HPUX_P_pkg.tar.gz HP-UX PA-RISC libhpodbc_p.sl. libhpodbc_drvr_p.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.cpp hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a. libhpodbc_drvr.a. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.
PAGE 54
7. Expand the installation and product files: • Linux: gunzip hpodbc__LINUX_pkg.tar.gz • x86_64 Linux: gunzip hpodbc__LINUX64_pkg.tar.gz • HP-UX (IA-64): gunzip hpodbc__HPUX_I_pkg.tar.gz • HP-UX (IA-64) 64 bit: gunzip hpodbc__HPUX_I_64_pkg.tar.gz • HP-UX (PA-RISC): gunzip hpodbc__HPUX_P_pkg.tar.gz • IBM AIX®: gunzip hpodbc__AIX_pkg.tar.gz 8. Extract the installation and product files. A directory called PkgTmp is created. • Linux: tar –xvf hpodbc__LINUX_pkg.
PAGE 55
http://www.unixodbc.org/ • For information on the necessary data source configuration options, you will need to add to the respective configuration files (odbc.ini). For more information, see the Neoview ODBC Drivers Manual at docs.hp.com: http://docs.hp.com/en/busintellsol.html. Running the Sample Program Note: the examples after each step assume that you have default installation directories.
PAGE 56
• On HP-UX (PA-RISC): aCC -AA connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc -lhppa -o connect_test -lm To use cc for compiling and linking: — — Rename connect_test.cpp to connect_test.c. Run this command: cc connect_test.c –L/usr/lib –I/usr/include/hpodbc \ -lhppa -lstd_v2 -lCsup_v2 -lm -lhpodbc -o connect_test • On IBM AIX®: g++ connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc -o connect_test 3. 4. If needed, modify the /etc/hpodbc/MXODSN file. Run the sample program: .
PAGE 57
Distribution File Supported Platform File Contents hpodbc__HPUX_P_pkg.tar.gz HP-UX PA-RISC libhpodbc_p.sl. libhpodbc_drvr_p.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.cpp hpodbc__AIX_pkg.tar.gz IBM AIX® libhpodbc.a. libhpodbc_drvr.a. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.
PAGE 58
• • 9. HP-UX (PA-RISC): tar –xvf hpodbc_vvv_hpux_P_pkg.tar.gz IBM AIX®: tar –xvf hpodbc__AIX_pkg.tar Install the product: cd PkgTmp ./install.sh Note: Except for the sample file, the install.sh script saves a copy (.SAV) of your previous installation files if they exist. 10. Accept the terms of the license agreement. 11. Enter a directory for the library files, or press Enter to use the default directory (/usr/lib). 12.
PAGE 59
2. Compile the sample program. Note: All drivers are 32-bit drivers; therefore, applications need to be compiled accordingly. • On Linux: gcc connect_test.cpp -L/usr/lib -I/usr/include/hpodbc \ -lhpodbc -o connect_test Note: The Linux driver is a 32-bit driver. If you are using an x86–64 machine, you need to explicitly compile your appplication as a 32-bit application. For example: gcc connect_test.
PAGE 60
Installation Package The HP Neoview ODBC Linux and HP-UX driver software is available in these downloadable distribution files: Distribution File Supported Platform File Contents hpodbc__Linux_pkg.tar.gz Linux libhpodbc_l.so..0.0 libhpodbc_drvr_l.so..0.0 MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.cpp hpodbc__HPUX_I_pkg.tar.gz HP-UX IA-64 libhpodbc_i.sl. libhpodbc_drvr_i.sl. MXODSN MD5SUM sql.h sqlext.h sqltypes.h install.h connect_test.
PAGE 61
6. Move the distribution file into the temporary directory: • Linux: hpodbc_vvv_LINUX_pkg.tar.gz • HP-UX (IA-64): hpodbc_vvv_hpux_I_pkg.tar.gz • HP-UX (PA-RISC): hpodbc_vvv_hpux_P_pkg.tar.gz 7. Expand the installation and product files: • Linux: gunzip hpodbc_vvv_LINUX_pkg.tar.gz • HP-UX (IA-64): gunzip hpodbc_vvv_hpux_I_pkg.tar.gz • HP-UX (PA-RISC): gunzip hpodbc_vvv_hpux_P_pkg.tar.gz 8. Extract the installation and product files. A directory called PkgTmp is created.
PAGE 62
http://www.unixodbc.org/ • For information on the necessary data source configuration options, you will need to add to the respective configuration files (odbc.ini). For more information, see the Neoview ODBC Drivers Manual at docs.hp.com: http://docs.hp.com/en/busintellsol.html. Running the Sample Program Note: the examples after each step assume that you have default installation directories.
PAGE 63
Related Product Documentation For more information about the ODBC Linux, HP-UX, and IBM AIX® drivers, see the HP Neoview ODBC Drivers Manual. This manual is available on the Business Intelligence Solutions page of docs.hp.com: http://docs.hp.com/en/busintellsol.html.
PAGE 64