I have a windows service on an app server that periodically calls a custom SharePoint web service on a SharePoint 2007 server. The custom SharePoint web service that is being called retrieves data from a SQL Server 2005 database and then sends out emails based on the data.
The SharePoint web service authenticates a windows user. That is, the app server that calls it sends credentials for a Windows app account on the SharePoint system.
The connection to the SharePoint web service occurs successfully and processing continues up until a retrieve data method uses a data adapter Fill method to fill a dataset retrieved from a Stored Procedure on the SQL Server. No Open method for the connection is performed (as it is implied in the Fill).
When the Fill method is executed, the following error is returned:
Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKey ...
Go to the complete details ...