SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64773: Reading data from a database with SAS/ACCESS® Interface to OLE DB takes more time than in previous SAS® versions

DetailsHotfixAboutRate It

When you use SAS/ACCESS Interface to OLE DB to read data from a database under the following conditions, you might experience slow performance:

  • You run SAS with UTF-8 encoding.
  • You use a LIBNAME statement.

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



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to OLE DBMicrosoft® Windows® for x649.4_M59.4 TS1M5
Microsoft Windows 8 Enterprise 32-bit9.4_M59.4 TS1M5
Microsoft Windows 8 Enterprise x649.4_M59.4 TS1M5
Microsoft Windows 8 Pro 32-bit9.4_M59.4 TS1M5
Microsoft Windows 8 Pro x649.4_M59.4 TS1M5
Microsoft Windows 8.1 Enterprise 32-bit9.4_M59.4 TS1M5
Microsoft Windows 8.1 Enterprise x649.4_M59.4 TS1M5
Microsoft Windows 8.1 Pro 32-bit9.4_M59.4 TS1M5
Microsoft Windows 8.1 Pro x649.4_M59.4 TS1M5
Microsoft Windows 109.4_M59.4 TS1M5
Microsoft Windows Server 20089.4_M59.4 TS1M5
Microsoft Windows Server 2008 R29.4_M59.4 TS1M5
Microsoft Windows Server 2008 for x649.4_M59.4 TS1M5
Microsoft Windows Server 2012 Datacenter9.4_M59.4 TS1M5
Microsoft Windows Server 2012 R2 Datacenter9.4_M59.4 TS1M5
Microsoft Windows Server 2012 R2 Std9.4_M59.4 TS1M5
Microsoft Windows Server 2012 Std9.4_M59.4 TS1M5
Microsoft Windows Server 20169.4_M59.4 TS1M5
Windows 7 Enterprise 32 bit9.4_M59.4 TS1M5
Windows 7 Enterprise x649.4_M59.4 TS1M5
Windows 7 Home Premium 32 bit9.4_M59.4 TS1M5
Windows 7 Home Premium x649.4_M59.4 TS1M5
Windows 7 Professional 32 bit9.4_M59.4 TS1M5
Windows 7 Professional x649.4_M59.4 TS1M5
Windows 7 Ultimate 32 bit9.4_M59.4 TS1M5
Windows 7 Ultimate x649.4_M59.4 TS1M5
* 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.