Usage Note 57905: Unknown and time-out errors occur when you use SAS/ACCESS® Interface to ODBC to read data from a SQLite database
When reading large amounts of SQLite data using SAS/ACCESS Interface to ODBC, you might receive the following error:
ERROR: CLI open cursor error: unknown error (7)
The problem occurs because of a bug in the SQLite ODBC driver. To resolve the problem, get the latest ODBC driver from Devart.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8 Enterprise x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8 Pro 32-bit | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8 Pro x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 8.1 Pro x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows 10 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows Server 2008 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows Server 2008 R2 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows Server 2008 for x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows Server 2012 Datacenter | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows Server 2012 R2 Std | 9.4_M3 | | 9.4 TS1M3 | |
| Microsoft Windows Server 2012 Std | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Enterprise 32 bit | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Enterprise x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Home Premium 32 bit | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Home Premium x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Professional 32 bit | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Professional x64 | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Ultimate 32 bit | 9.4_M3 | | 9.4 TS1M3 | |
| Windows 7 Ultimate x64 | 9.4_M3 | | 9.4 TS1M3 | |
*
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.
Unknown and time-out errors might occur when reading large amounts of data from a SQLite database using SAS/ACCESS Interface to ODBC.
| Date Modified: | 2016-04-09 16:52:14 |
| Date Created: | 2016-03-21 12:38:01 |
