README for the HP Neoview ODBC UNIX Drivers HP Part Number: 546517-001 Published: October 2008 Edition: HP Neoview Release 2.3 Service Pack 2 (Client Update 3 for Release 2.
© Copyright 2008 Hewlett-Packard Development Company, L.P. Legal Notice Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Table of Contents Checking Version Compatibility............................................................................................................5 Getting the Version of an Installed Client Product...........................................................................5 Installation for Neoview Release 2.3......................................................................................................6 Installation Package...................................................................
Checking Version Compatibility Before installing the client product, check the compatibility of the product with the Neoview platform. Neoview Release of Client Product the Client Product Name Compatible versions of the Neoview platform 2.0 ODBC UNIX Drivers All versions up to, but not including, Neoview Release 2.2 2.1 ODBC UNIX Drivers All versions up to, but not including, Neoview Release 2.2 2.2 ODBC UNIX Drivers Neoview Release 2.2 and later versions 2.
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.
NOTE: These instructions do not necessarily apply to updates earlier than the client update number shown on the title page of this document. • • • Installation Package Installation Requirements Installation Instructions Installation Package The HP Neoview UNIX driver software is available in these downloadable distribution files: Distribution File Supported Platform File Contents hpodbc_T0775_2.3._Linux_pkg.tar.gz x86 Linux libhpodbc_l.so. libhpodbc_drvr_l.so. MXODSN MD5SUM sql.
Distribution File Supported Platform File Contents hpodbc_T0775_2.3._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 8 hpodbc_T0775_2.3._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_T0775_2.3._HPUX_P_64_pkg.tar.
Distribution File Supported Platform File Contents hpodbc_T0775_2.3._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_T0775_2.3._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.
6. Move the distribution file into the temporary directory: • Linux: hpodbc_T0775_2.3._LINUX_pkg.tar.gz • x86_64 Linux: hpodbc_T0775_2.3._LINUX64_pkg.tar.gz • IA-64 Linux: hpodbc_T0775_2.3._LINUXIA64_pkg.tar.gz • HP-UX (IA-64): hpodbc_T0775_2.3._HPUX_I_pkg.tar.gz • HP-UX (IA-64) 64 bit: hpodbc_T0775_2.3._HPUX_I_64_pkg.tar.gz • HP-UX (PA-RISC): hpodbc_T0775_2.3._HPUX_P_pkg.tar.gz • HP-UX (PA-RISC) 64 bit: hpodbc_T0775_2.3._HPUX_P_64_pkg.
Note: For the AIX drivers, a prompt will ask if you want to install the HP ODBC library that was compiled, the AIX xlc/xlc++ compilers, or the gcc/g++ compiler for AIX. 12. Enter a directory for the data source template file, or press Enter to use the default directory (/etc/hpodbc). 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).
1. Move to the directory where you installed the sample program: cd /etc/hpodbc/sample 2. Compile the sample program. Note: All drivers, other than the 64-bit driver for HP-UX(IA-64), x86_64 Linux driver, and IA-64 Linux are 32-bit drivers; therefore, applications need to be compiled accordingly. • On x86 Linux: g++ connect_test.cpp -L/usr/lib -I/usr/include/hpodbc -lhpodbc \ -o connect_test Note: This Linux driver is a 32-bit driver.
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): 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.
-lhpodbc64 -o connect_test 3. 4. If needed, modify the /etc/hpodbc/MXODSN file. Run the sample program: ./connect_test -d -u -p Related Product Documentation For more information about the ODBC UNIX 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.
