Usage Note 4198: When using the OLE DB Jet 4.0 provider shipped with the MDAC, Version
2.1.2 GA and Version 2.5 release, the OLEDB libname engine will
improperly delete records.
When using the OLE DB Jet 4.0 provider shipped with the MDAC, Version
2.1.2 GA and Version 2.5 release, the OLEDB libname engine will
incorrectly delete only two records. It will delete only two records
although there are more records that should be deleted.
For example:
libname test oledb provider="Microsoft.Jet.OLEDB.4.0" properties=("user
id=xxxx "data source"='filename');
data test.a;
x=1; y='new1'; output;
x=2; y='new2'; output;
x=4; y='new4'; output;
x=3; y='new3'; output;
x=4; y='new5'; output;
x=4; y=;new6'; output;
run;
/*should delete 3 records*/
proc sql;
delete from test.a where x=4;
quit;
There is no circumvention for this problem.
This is a Microsoft bug. For more information regarding this
problem, contact Microsoft for any hot fixes available for the
OLE DB Jet 4.0 provider.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft Windows 95/98 | 8 TS M0 | |
| Microsoft Windows NT Workstation | 8 TS M0 | |
| Microsoft Windows 2000 Advanced Server | 8 TS M0 | |
| Microsoft Windows 2000 Datacenter Server | 8 TS M0 | |
| Microsoft Windows 2000 Server | 8 TS M0 | |
| Microsoft Windows 2000 Professional | 8.1 TS1M0 | |
*
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.
| Type: | Usage Note |
| Priority: | alert |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> OLEDB
Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database)
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2001-06-25 13:42:05 |
| Date Created: | 2001-01-26 10:40:06 |
