Hi..

I am getting an error message (from an ASP )
Microsoft OLE DB Provider for SQL Server (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status 
value, if available. No work was done.

at the code...
strQrySql="EXEC DshBrd_main_SP " & Trim(objRs1("hSiERtdb"))
objrs.Open strQrySql,objCon,adOpenDynamic,adLockReadOnly,adCmdText
If objrs.EOF Then <--- error :-(

the Stored procedure is running fine when I run it from the Microsoft 
Query analyzer.It takes around 1minute 40 seconds to finish.
My timeout settings are
objCon.CommandTimeout = 10000000

and it takes exactly 43 seconds before the page fails.
The SP has one curson inside it, and it updates another table by taking 
data from the cursor.the No of rows inserted is different in each run.
I have included adovbs.inc at the top of ASP.

Can anyone help me please... I am stuck with this..

Thanks
Jithin