We have developed a COM based Client-Server application. The UI makes request to the Server which is a COM (MyServer.dll) DLL. This DLL in turn calls another generic COM component (DBWrapper.dll) for Database access. MyServer.dll is to be deployed on COM+ on a different machine than that of UI and DBWrapper will be deployed on the same machine as MyServer.dll and is to be instantiated as In-Proc (NO COM+).
If we instantiate MyServer as a In-Proc server the application works fine. But if I deploy MyServer on COM+ the DBWrapper behaves erratic. Some times it gives proper response and sometimes it returns error. We have no clue as to what is wrong. The behaviour is random and it can't be predicted which specific call causes failure.
Can anybody tell me what might be going wrong in this scenario? I am using ATL with C++ for sever and the component threading model is both.
Thanks in advance