I'm not familiar with how OLEDB works so I hope someone here can tell me.
We have a Sage 100 ERP 5.2 as a linked server in MSSQL2008. Some scripts in Sage executes stored procs in SQL at post-write and post-validate events. Most of the time there is no problem. But about one every 100-1000 executions results in indefinite OLEDB Wait type and the instance has to be restarted. Since it's sporadic, it took me a while to capture them in Profiler but I found that every time it happens, it stops at a particular method, IDBInitialize::Initialize. After that SQL keeps waiting for the response from Sage, which I believe should be zero.
The question is....what could be causing Sage to not respond? Where else should I look? Both are running on the same server, and the scripts are server-side.
Many thanks.
Ken