INSTALLATION INSTRUCTIONS FOR HOT FIX 82OD09 ON WINDOWS BEFORE DOWNLOADING: The hot fix 82OD09 addresses the issue(s) in Release 8.2 (TS2M0) of SAS/ACCESS Interface to ODBC Server software on Windows as documented in SAS Note(s): SN-006004 "ERROR: CLI open cursor error: [IBM][CLI Driver] CLI0125E Function sequence error" issued when using SAS/ACCESS Interface to DB2 SN-005708 ERROR: SQL0514N The cursor "SQLCURCS297" is not in prepared state SN-006276 New special queries added for ODBC and DB2: SQLDataSources and SQLDBMSInfo SN-005997 Access AS400 data using Access Interface to ODBC can cause ERROR:[merant][ODBC driver][DB2/400] Keyword FOR not expected. SN-005996 Access Interface to ODBC when accessing MSAccess data may cause data to be overwritten if using APPEND operations SN-005330 PROC APPEND to SQL Server using BCP option will insert data incorrectly SN-004053 CLI ODBC driver error occurs when using SAS/ACCESS Interface to ODBC to access LANDMARK DBMS, through LANDMARK ODBC driver SN-006323 Unable to get a single connection when using CONNECTION=GLOBALREAD as documentation would suggest SN-006293 Read Isolation Level defaults to CR when using SAS/Access Interface to DB2 SN-006312 CLI prepare error using NEON ODBC Driver to access DB2 on MVS with Access to ODBC on Windows SN-007694 NonStop Tandem LARGEINT columns causes problems with Access to ODBC V8.2 on Windows SN-008603 "No data found" error occurs when trying to update or delete from a DB2 table with SQL SN-009478 SAS/Access to ODBC accessing Sql Server 2000 generates errors when creating a temporary table SN-009773 Incorrect data when KEEP= contains a field with a binary data type SN-009914 /UNIQUE option does not work with ODBC engine for character typed variables SN-012061 "ERROR: No matching observation was found in MASTER data set" is issued after applying HOTFIX 82D220 SN-013571 Bus Error accessing DBMS table via SAS/ACCESS to ODBC with rowset_size >1 SN-013504 SQL3061N received bulkloading to a DB2 table in a DBCS database SN-013980 DB2 bulk loader does not run with ALLOW READ ACCESS enabled which may be reviewed at: http://support.sas.com/techsup/unotes/SN/006/006004.html http://support.sas.com/techsup/unotes/SN/005/005708.html http://support.sas.com/techsup/unotes/SN/006/006276.html http://support.sas.com/techsup/unotes/SN/005/005997.html http://support.sas.com/techsup/unotes/SN/005/005996.html http://support.sas.com/techsup/unotes/SN/005/005330.html http://support.sas.com/techsup/unotes/SN/004/004053.html http://support.sas.com/techsup/unotes/SN/006/006323.html http://support.sas.com/techsup/unotes/SN/006/006293.html http://support.sas.com/techsup/unotes/SN/006/006312.html http://support.sas.com/techsup/unotes/SN/007/007694.html http://support.sas.com/techsup/unotes/SN/008/008603.html http://support.sas.com/techsup/unotes/SN/009/009478.html http://support.sas.com/techsup/unotes/SN/009/009773.html http://support.sas.com/techsup/unotes/SN/009/009914.html http://support.sas.com/techsup/unotes/SN/012/012061.html http://support.sas.com/techsup/unotes/SN/013/013571.html http://support.sas.com/techsup/unotes/SN/013/013504.html http://support.sas.com/techsup/unotes/SN/013/013980.html IMPORTANT NOTE(S): 1. You must have Release 8.2 (TS2M0) installed on your system before applying this hot fix. 2. You must have Administrator Privileges on your CLIENT or SERVER machine and all currently active SAS sessions, daemons, spawners and servers must be terminated before applying this hot fix. AFTER DOWNLOADING: The hot fix package downloaded is a self extracting executable named 82od09wn.exe. Launching the executable will initiate the install wizard, which will guide you through the setup process. The following files will be installed: * sasbcp.dll the replacement module containing the hot fix * sasdblpa.dll the replacement module containing the hot fix * sasodbcb.dll the replacement module containing the hot fix * sascv2od.dll the replacement module containing the hot fix * sasioodb.dll the replacement module containing the hot fix * sasodbdb.dll the replacement module containing the hot fix * sasdblda.dll the replacement module containing the hot fix * sasodb.dll the replacement module containing the hot fix * sasdbu.dll the replacement module containing the hot fix * sasdbub.dll the replacement module containing the hot fix * sasdbudb.dll the replacement module containing the hot fix * sasiodbu.dll the replacement module containing the hot fix * dbidbu.msg the replacement message file containing the hot fix * 82od09wn.aud a hot fix identifier file that will allow Technical Support to determine which fixes have been applied to a system * 82od09wn.txt a copy of these installation instructions; this file is installed in !SASROOT\core\sasinst\hotfix This completes the installation of hot fix 82OD09 on Windows.