11-17-2015 05:11 AM
I have a .NET WCF service which connects with SAS 9.4 and brings data, so basically I form lib, path and query and using OleDbConnection read the datatable. So on start of wcf application, i make a connecting and let workspace object as static and re-using same workspace for all read operations. It work fine till some extend and after sometime I am Not sure why i am facing below issue.
1. System.Runtime.InteropServices.COMException (0x80010108): The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))
2. System.Runtime.InteropServices.COMException (0x80010108): End of data set reached.
Do you have any solution for this problem, please let me know. for now i am going with workaround of reconnecting workspace and re-trigger same query to get result.