Usage Note 40613: "Unable to IDBInitialize" errors when using SAS 9.2
 |  |  |  |
When attempting to import or export to Microsoft Excel or Microsoft Access files in 9.2 of the SAS system, you can receive the following error:
ERROR: Connect: Unable to IDBInitialize ERROR: Error in the LIBNAME statement. NOTE: Attachments for -9 reestablished for new parent. NOTE: Export Cancelled.
The problem can occur even when version 9.1 of the SAS system works correctly.
This happens because SAS 9.2 relies on the Microsoft Access Connectivity Engine and 9.1 uses the Microsoft Joint Engine Technology. To resolve the problem install the Microsoft Data Connectivity Components for Office 2007. Microsoft Office 2007 is not required in order to install these components. You can also use these components to install the latest Microsoft ODBC and OLEDB drivers.
You can change the display language dependent on the language of the machine.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | |||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M0 | |||
| Microsoft Windows XP Professional | 9.2 TS2M0 | |||
| Windows Vista | 9.2 TS2M0 | |||
| Windows Vista for x64 | 9.2 TS2M0 | |||
When using 9.2 of the SAS system to access Microsoft Excel or Microsoft Access files, you can receive "Unable to IDBInitialize" errors. This means that the 2007 Microsoft ACE drivers are not installed.
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Access Data Management ==> Data Sources ==> External Databases ==> MS Excel |
| Date Modified: | 2010-12-20 17:48:50 |
| Date Created: | 2010-08-17 14:14:49 |