Problem Note 45835: A CLI error occurs when you try to establish a connection while importing Excel files with the EXCELCS engine and the SAS® PC Files Server
When you import an Excel file using either the IMPORT wizard or the LIBNAME statement and you specify the EXCELCS engine, you might receive an error message similar to the following:
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] Reserved error (-5016);
there is no message for this error.
The SAS/ACCESS® Interface to PC Files uses an ODBC driver to read data into SAS when the PC Files Server is used. This ODBC driver requires a Write lock on your Excel file. You receive the error when the driver cannot access your Excel file because the file is Write protected.
To avoid the error, remove Write protection from your Excel file.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for x64 | 9.2 TS2M3 | |
Microsoft Windows XP 64-bit Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M3 | |
Windows 7 Home Premium 32 bit | 9.2 TS2M3 | |
Windows 7 Home Premium x64 | 9.2 TS2M3 | |
Windows 7 Enterprise x64 | 9.2 TS2M3 | |
Windows 7 Enterprise 32 bit | 9.2 TS2M3 | |
Microsoft Windows XP Professional | 9.2 TS2M3 | |
Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | |
Microsoft Windows Server 2008 | 9.2 TS2M3 | |
Microsoft Windows Server 2003 for x64 | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M3 | |
Windows 7 Professional 32 bit | 9.2 TS2M3 | |
Windows 7 Professional x64 | 9.2 TS2M3 | |
Windows 7 Ultimate 32 bit | 9.2 TS2M3 | |
Windows 7 Ultimate x64 | 9.2 TS2M3 | |
Windows Vista | 9.2 TS2M3 | |
Windows Vista for x64 | 9.2 TS2M3 | |
64-bit Enabled AIX | 9.2 TS2M3 | |
64-bit Enabled HP-UX | 9.2 TS2M3 | |
64-bit Enabled Solaris | 9.2 TS2M3 | |
HP-UX IPF | 9.2 TS2M3 | |
Linux | 9.2 TS2M3 | |
Linux for x64 | 9.2 TS2M3 | |
Solaris for x64 | 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.
When you import an Excel file using the EXCELCS engine and the SAS PC Files Server, you can get a CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] Reserved error (-5016) message. The problem occurs when the Excel file is Write protected.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2012-06-29 14:17:35 |
Date Created: | 2012-02-28 14:31:15 |