Usage Note 44146: Connection failed errors when reading Microsoft Access files using the SAS PC Files Server
When you are importing Microsoft Access files using the SAS PC Files Server, the following error might occur:
ERROR: CLI open cursor error: [Microsoft][ODBC Microsoft Access Driver]
ODBC--connection to 'tablename' failed.
ERROR: Import unsuccessful. See SAS Log for details.
The issue can occur even if you are able to import other Microsoft Access files and tables. The problem occurs because the Microsoft Access file that is being read has links to other files or tables that do not exist.
To resolve the problem, change the links in the Microsoft Access file itself or obtain the missing files that the table requires.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21_M2 | | | |
| Microsoft Windows XP 64-bit Edition | 9.21_M2 | | | |
| Microsoft® Windows® for x64 | 9.21_M2 | | | |
| Microsoft Windows Server 2003 for x64 | 9.21_M2 | | | |
| Microsoft Windows Server 2008 for x64 | 9.21_M2 | | | |
| Windows 7 Enterprise x64 | 9.21_M2 | | | |
| Windows 7 Home Premium x64 | 9.21_M2 | | | |
| Windows 7 Professional x64 | 9.21_M2 | | | |
| Windows 7 Ultimate x64 | 9.21_M2 | | | |
| Windows Vista for x64 | 9.21_M2 | | | |
| 64-bit Enabled AIX | 9.21_M2 | | | |
| 64-bit Enabled HP-UX | 9.21_M2 | | | |
| 64-bit Enabled Solaris | 9.21_M2 | | | |
| HP-UX IPF | 9.21_M2 | | | |
| Linux | 9.21_M2 | | | |
| Linux for x64 | 9.21_M2 | | | |
| Solaris for x64 | 9.21_M2 | | | |
*
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.
"Connection failed" errors might occur when you are reading Microsoft Access files using the SAS/ACCESS
® driver.
| Date Modified: | 2011-11-08 09:46:15 |
| Date Created: | 2011-08-29 17:24:21 |
