P
pointguards
I'm running a SQL 2000 stored procedure from Access client using
SQLOLEDB provider and ADO Command object. The stored procedure only
returns a Return Value and no recordset.
When ran from Query Analyzer, it runs in less than 4 seconds. When ran
from Access client using objects noted above, it takes whopping 40
seconds and it times out!! Ran SQL profiler, but I cannot see anything
suspicious because it all occurrs within a stored procedure. Event
viewer of the server where the Access client is running from revealed
next to nothing. Is there a chance that overhead from ADO command
object is slowing the execution ?
If anyone could think of a reason why a same procedure will run much
slower within ADO command object, please help!!!!
SQLOLEDB provider and ADO Command object. The stored procedure only
returns a Return Value and no recordset.
When ran from Query Analyzer, it runs in less than 4 seconds. When ran
from Access client using objects noted above, it takes whopping 40
seconds and it times out!! Ran SQL profiler, but I cannot see anything
suspicious because it all occurrs within a stored procedure. Event
viewer of the server where the Access client is running from revealed
next to nothing. Is there a chance that overhead from ADO command
object is slowing the execution ?
If anyone could think of a reason why a same procedure will run much
slower within ADO command object, please help!!!!