Hi Qu1ncy,
Cool! Thanks for the effort in paving for a good insight on what's causing the prob--which has something to do with a no. of factors that aborts a SQL connection for a return set back to a requesting client.
The documentation pointed out in page 163 has been very helpful, with similar terms used in that of MS SQL Server's-- where my CR report connects to--(which is not surprising as it had its roots from Sybase SQL Server). Thank you.
I'm left with still one issue though:
At the time I received the "DBProcess is dead or not enabled" runtime msg in Crystal, I tried refreshing SQL Analyzer for the report's same underlying stored procedure; and, as opposed to what was expected, I was able to connect. Hmmm... strange!? (just my curiosity ;-))
Tnx again.