Problem Note 45209: SAS® Add-In 4.3 for Microsoft Office and SAS® Enterprise Guide® might produce a System.EnterpriseServices error when you connect to the SAS server
 |  |  |  |
In Microsoft Office applications, such as Excel, the following error might occur if you use SAS Add-In 4.3 for Microsoft Office and attempt to connect to the SAS server:
The requested operation could not be performed by the SAS server. -------------------------------------------------------- Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the path specified. ------------------------------ Technical Information Follows ------------------------------ SAS.EG.SDS.SDSException: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the path specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the path specified. File name: 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' ---> System.IO.DirectoryNotFoundException: The system cannot find the path specified. (Exception from HRESULT: 0x80070003) at System.Data.Common.ADP.IsSysTxEqualSysEsTransaction() at System.Data.Common.ADP.NeedManualEnlistment() at System.Data.OleDb.OleDbConnection.Open() at SAS.EG.SDS.Model.Server.GetServerLibraries() --- End of inner exception stack trace --- at SAS.EG.SDS.Model.Server.GetServerLibraries() at SAS.EG.SDS.Model.Server.PopulateLibraries(Collection& collection) at SAS.EG.SDS.Model.Broker.PopulateCollection(Collection collection) at SAS.EG.SDS.Model.Collection.DoPopulate() at SAS.EG.SDS.Model.Collection.Populate() at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op) ------------------------------ End of Technical Information ------------------------------
If you open the file directly, an unable to open data source error occurs too:
Similar errors might occur in SAS Enterprise Guide when you are connecting to a SAS server.
This indicates a problem with the Microsoft .NET Framework 2.0 installation on the machine.
To remedy this error, repair or reinstall Microsoft .NET 2.0 Framework. The Microsoft .Net Framework is a free download available from the Microsoft Web site.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Windows 7 Professional x64 | 4.2 | 9.2 TS2M2 | ||
| Windows 7 Professional 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows XP Professional | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 for x64 | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 for x64 | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 9.2 TS2M2 | ||||
| Microsoft® Windows® for x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Ultimate 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Ultimate x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows Vista | 4.2 | 9.2 TS2M2 | ||||
| Windows Vista for x64 | 4.2 | 9.2 TS2M2 | ||||
| SAS System | SAS Add-in for Microsoft Office | Windows Vista for x64 | 4.2 | 9.2 TS2M2 | ||
| Windows Vista | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Ultimate x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Ultimate 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Professional x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Professional 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Home Premium 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise x64 | 4.2 | 9.2 TS2M2 | ||||
| Windows 7 Enterprise 32 bit | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows XP Professional | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 for x64 | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 for x64 | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 9.2 TS2M2 | ||||
| Microsoft® Windows® for x64 | 4.2 | 9.2 TS2M2 | ||||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-01-23 10:19:02 |
| Date Created: | 2011-12-22 00:18:29 |