42537 - An error is produced if no result set is generated with SAS/ACCESS® 9.2 Interface to OLE DB

Problem Note 42537: An error is produced if no result set is generated with SAS/ACCESS® 9.2 Interface to OLE DB

SAS/ACCESS 9.2 Interface to OLE DB generates an error if no result set is produced with a PROC SQL SELECT statement:

"ERROR: No data found/modified"

Click the Hot Fix tab in this note to access the hot fix for this issue.

This hot fix change the error to a note so that SAS^® 9.2 behaves the same as SAS 9.1.3.

Product Family	Product	System	SAS Release
Product Family	Product	System	Reported	Fixed*
SAS System	SAS/ACCESS Interface to OLE DB	Microsoft Windows Server 2003 Datacenter Edition	9.2 TS2M3	9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS2M3	9.2 TS2M3
		Microsoft Windows Server 2003 Standard Edition	9.2 TS2M3	9.2 TS2M3
		Microsoft Windows Server 2008	9.2 TS2M3	9.2 TS2M3
		Microsoft Windows XP Professional	9.2 TS2M3	9.2 TS2M3
		Windows 7 Enterprise 32 bit	9.2 TS2M3	9.2 TS2M3
		Windows 7 Home Premium 32 bit	9.2 TS2M3	9.2 TS2M3
		Windows 7 Professional 32 bit	9.2 TS2M3	9.2 TS2M3
		Windows 7 Ultimate 32 bit	9.2 TS2M3	9.2 TS2M3
		Windows Vista	9.2 TS2M3	9.2 TS2M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for this issue for SAS/ACCESS Interface to OLE DB 9.21_M2 is available at:

SAS/ACCESS Interface to OlE DB generates the error "ERROR: No data found/modified" if no result set is produced for a PROC SQL SELECT statement.

Type:	Problem Note
Priority:	medium

Date Modified:	2011-03-01 11:48:09
Date Created:	2011-02-28 08:23:23