Patch Name: PHSS_29521

Patch Description: s700_800 10.20 ODBCLINK/SE G.02.00 Run-Time Patch

Creation Date: 03/07/30

Post Date: 03/08/06

Hardware Platforms - OS Releases:
	s700: 10.20
	s800: 10.20

Products:
	HP SQL/HP-UX A.G3.31 A.G3.28 A.G3.23 A.G3.17 A.G3.14

Filesets:
	ALLBASE-SQL.AB-ODBCSE,G.02.00,G.00.01,G.00.00,F.03.05
	ALLBASE-SQL.AB-ODBCSE,F.00.00,E.58.03

Automatic Reboot?: No

Status: General Release

Critical: No

Path Name: /hp-ux_patches/s700_800/10.X/PHSS_29521

Symptoms:
	PHSS_29521:

	SR# 8606318396
	ODBCLINK returning SQL_ERROR for SQLColAttributes
	attribute 1212

	PHSS_27717:

	SR# 8606179209
	ODBCLink/SE does not work with trusted system

	SR# 8606273519
	ODBClink/SE doesn't work with MSExcel -
	Data Transmission error

	PHSS_26983:
	SR# 8606243286
	Procedure column of type DATETIME returned as unknown

	PHSS_26480:

	SR# 8606231415
	odbclink/se f.00.00 failues with dberr 2103 with
	ms access 2000

	SR# 8606176910
	dberr 2103 after doing a stopping a select mid way
	though - odbclink/se

	PHSS_23358:

	SR# 8606157045
	dberr 2103 when doing a lock table on odbclink/se 58.03

	SR# 8606133019
	Using Visual Basic RDO query returns max of 200 rows on a
	second select

	SR# 8606168718
	ODBCLink/SE SQLAllocStmt fails: Can't change timeout on
	active statement

Defect Description:
	PHSS_29521:

	SR# 8606318396
	ODBCLINK returning SQL_ERROR for SQLColAttributes
	attribute 1212

	PHSS_27717:

	SR# 8606179209
	ODBCLink/SE does not work with trusted system

	SR# 8606273519
	ODBClink/SE doesn't work with MSExcel -
	Data Transmission error

	PHSS_26983:

	SR# 8606243286
	Procedure column of type DATETIME returned as unknown

	PHSS_26480:

	SR# 8606231415
	odbclink/se f.00.00 failues with dberr 2103 with
	ms access 2000

	SR# 8606176910
	dberr 2103 after doing a stopping a select mid way
	though - odbclink/se

	PHSS_23358:

	SR# 8606157045
	dberr 2103 when doing a lock table on odbclink/se 58.03

	SR# 8606133019
	Using Visual Basic RDO query returns max of 200 rows on a
	second select

	SR# 8606168718
	ODBCLink/SE SQLAllocStmt fails: Can't change timeout on
	active statement

SR:
	8606157045 8606133019 8606168718 8606231415 8606176910
	8606243286 8606179209 8606273519 8606318396

Patch Files:
	/opt/allbase/bin/odbcse/HPREADME
	/opt/allbase/bin/odbcse/odbccl32
	/opt/allbase/bin/odbcse/odbclnse
	/opt/allbase/bin/odbcse/odbcutse

what(1) Output:
	/opt/allbase/bin/odbcse/HPREADME:
		None
	/opt/allbase/bin/odbcse/odbccl32:
		None
	/opt/allbase/bin/odbcse/odbclnse:
		$header:  ODBCHOST.C 1.98 THU, NOV 28, 2002, 9:47 AM
		JOHNM.ODBCLINK $
		$revision:  1.98 $
		$header:  ODBCCONS.C 1.31 FRI, MAY 3, 2002, 12:25 PM
		JOHNM.ODBCLINK $
		$revision:  1.31 $
		$header:  ODBCSERV.C 1.137 TUE, MAR 18, 2003, 4:42
		PM MGR.ODBCLINK $
		$revision:  1.137 $
		$header:  ODBCCOMH.C 1.45 THU, MAY 2, 2002, 5:38 PM
		JOHNM.ODBCLINK $
		$revision:  1.45 $
		$header:  ODBCFMT.C 1.98 WED, NOV 27, 2002, 9:45 AM
		MGR.ODBCLINK $
		$revision:  1.98 $
		$header:  VERSJR.C 1.3 TUE, MAR 19, 2002, 3:52 PM
		MGR.ODBCLINK $
		$revision:  1.3 $
		$header:  PARSE.C 1.123 THU, MAR 6, 2003, 5:24 PM
		JOHNM.ODBCLINK $
		$revision:  1.123 $
		$header:  OPEN.C 1.199 TUE, MAR 18, 2003, 4:44 PM
		MGR.ODBCLINK $
		$revision:  1.199 $
		$header:  ERROR.C 1.20 TUE, NOV 26, 2002, 1:33 PM
		JOHNM.ODBCLINK $
		$revision:  1.20 $
		$header:  DATACONV.C 1.89 WED, FEB 12, 2003, 2:10 PM
		JOHNM.ODBCLINK $
		$revision:  1.89 $
		$header:  FETCH.C 1.102 SUN, JAN 12, 2003, 11:52 PM
		JOHNM.ODBCLINK $
		$revision:  1.102 $
		$header:  NONSQL.C 1.34 FRI, MAR 7, 2003, 11:50 AM
		JOHNM.ODBCLINK $
		$revision:  1.34 $
		$header:  QUERY.C 1.75 MON, MAR 17, 2003, 11:00 AM
		JOHNM.ODBCLINK $
		$revision:  1.75 $
		$header:  SECURE.C 1.21 WED, SEP 11, 2002, 10:03 AM
		JOHNM.ODBCLINK $
		$revision:  1.21 $
		$header:  SQL.C 1.12 FRI, MAR 7, 2003, 5:47 PM
		JOHNM.ODBCLINK $
		$revision:  1.12 $
		$header:  STUBS.C 1.25 THU, AUG 1, 2002, 10:50 AM
		JOHNM.ODBCLINK $
		$revision:  1.25 $
		$header:
		$revision:  1.1 $
		$header:  ALLBASER.C 1.69 FRI, MAR 7, 2003, 10:22 AM
		JOHNM.ODBCLINK $
		$revision:  1.69 $
		$header:  ALLBASEX.PC 1.19 MON, JAN 6, 2003, 2:58 PM
		JOHNM.ODBCLINK $
		$revision:  1.19 $
		$header:  ORASTUBS.C 1.3 MON, OCT 21, 2002, 11:23 AM
		JOHNM.ODBCLINK $
		$revision:  1.3 $
		HP36217-02A.G3.04 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.04.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 02/03/99
		HP36217-02A.G3.04 NET AF Library ALLBASE/SQL
		02/02/99
		HP36217-02A.G3.04 NET Library ALLBASE/SQL 02/02/99
		HP36217-02A.G3.04 NET VC Library ALLBASE/SQL
		02/02/99
		PATCH-PHCO_17381 for 10.20; for 10.30, 11.x
		compatibility libc.a_ID@@/main/r10dav/libc_dav/15
		/ux/core/libs/libc/archive_pa1/libc.a_ID
		Mar 9 1999 13:52:37
	/opt/allbase/bin/odbcse/odbcutse:
		$header:  ODBCUTIL.C 1.82 TUE, MAR 18, 2003, 4:39 PM
		MGR.ODBCLINK $
		$revision:  1.82 $
		$header:  VERSJR.C 1.3 TUE, MAR 19, 2002, 3:52 PM
		MGR.ODBCLINK $
		$revision:  1.3 $
		$header:  PARSE.C 1.123 THU, MAR 6, 2003, 5:24 PM
		JOHNM.ODBCLINK $
		$revision:  1.123 $
		$header:  OPEN.C 1.199 TUE, MAR 18, 2003, 4:44 PM
		MGR.ODBCLINK $
		$revision:  1.199 $
		$header:  ERROR.C 1.20 TUE, NOV 26, 2002, 1:33 PM
		JOHNM.ODBCLINK $
		$revision:  1.20 $
		$header:  DATACONV.C 1.89 WED, FEB 12, 2003, 2:10 PM
		JOHNM.ODBCLINK $
		$revision:  1.89 $
		$header:  FETCH.C 1.102 SUN, JAN 12, 2003, 11:52 PM
		JOHNM.ODBCLINK $
		$revision:  1.102 $
		$header:  NONSQL.C 1.34 FRI, MAR 7, 2003, 11:50 AM
		JOHNM.ODBCLINK $
		$revision:  1.34 $
		$header:  QUERY.C 1.75 MON, MAR 17, 2003, 11:00 AM
		JOHNM.ODBCLINK $
		$revision:  1.75 $
		$header:  SECURE.C 1.21 WED, SEP 11, 2002, 10:03 AM
		JOHNM.ODBCLINK $
		$revision:  1.21 $
		$header:  SQL.C 1.12 FRI, MAR 7, 2003, 5:47 PM
		JOHNM.ODBCLINK $
		$revision:  1.12 $
		$header:  STUBS.C 1.25 THU, AUG 1, 2002, 10:50 AM
		JOHNM.ODBCLINK $
		$revision:  1.25 $
		$header:
		$revision:  1.1 $
		$header:  ALLBASER.C 1.69 FRI, MAR 7, 2003, 10:22 AM
		JOHNM.ODBCLINK $
		$revision:  1.69 $
		$header:  ALLBASEX.PC 1.19 MON, JAN 6, 2003, 2:58 PM
		JOHNM.ODBCLINK $
		$revision:  1.19 $
		$header:  ORASTUBS.C 1.3 MON, OCT 21, 2002, 11:23 AM
		JOHNM.ODBCLINK $
		$revision:  1.3 $
		HP36217-02A.G3.04 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.04.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 02/03/99
		HP36217-02A.G3.04 NET AF Library ALLBASE/SQL
		02/02/99
		HP36217-02A.G3.04 NET Library ALLBASE/SQL 02/02/99
		HP36217-02A.G3.04 NET VC Library ALLBASE/SQL
		02/02/99
		PATCH-PHCO_17381 for 10.20; for 10.30, 11.x
		compatibility libc.a_ID@@/main/r10dav/libc_dav/15
		/ux/core/libs/libc/archive_pa1/libc.a_ID
		Mar 9 1999 13:52:37

cksum(1) Output:
	1734747533 9218 /opt/allbase/bin/odbcse/HPREADME
	2705471733 4581376 /opt/allbase/bin/odbcse/odbccl32
	882072212 3731288 /opt/allbase/bin/odbcse/odbclnse
	4280202971 3495560 /opt/allbase/bin/odbcse/odbcutse

Patch Conflicts: None

Patch Dependencies: None

Hardware Dependencies: None

Other Dependencies: None

Supersedes:
	PHSS_23358 PHSS_26480 PHSS_26983 PHSS_27717

Equivalent Patches:
	PHSS_29522:
	s700: 11.00
	s800: 11.00

Patch Package Size: 6950 KBytes

Installation Instructions:
	Please review all instructions and the Hewlett-Packard
	SupportLine User Guide or your Hewlett-Packard support terms
	and conditions for precautions, scope of license,
	restrictions, and, limitation of liability and warranties,
	before installing this patch.
	------------------------------------------------------------
	1. Back up your system before installing a patch.

	2. Login as root.

	3. Copy the patch to the /tmp directory.

	4. Move to the /tmp directory and unshar the patch:

		cd /tmp
		sh PHSS_29521

	5a. For a standalone system, run swinstall to install the
	    patch:

		swinstall -x autoreboot=true -x match_target=true \
			-s /tmp/PHSS_29521.depot

	By default swinstall will archive the original software in 
	/var/adm/sw/patch/PHSS_29521.  If you do not wish to retain a
	copy of the original software, you can create an empty file
	named /var/adm/sw/patch/PATCH_NOSAVE. 

	WARNING: If this file exists when a patch is installed, the 
	         patch cannot be deinstalled.  Please be careful
		 when using this feature.

	It is recommended that you move the PHSS_29521.text file to 
	/var/adm/sw/patch for future reference.

	To put this patch on a magnetic tape and install from the
	tape drive, use the command:

		dd if=/tmp/PHSS_29521.depot of=/dev/rmt/0m bs=2k

Special Installation Instructions:
	From version F.00.00 onward client support for 16-bit
	is not provided. The client file ODBCCL32 is now a
	"ZIP" file rather than a self extracting executable.
	You may need WINZIP to extract the files.