HELP !! Running SQL 2000 using ADO command object from Access 2000
- From: pointguards@xxxxxxxxxxx
- Date: 10 Jan 2007 13:53:01 -0800
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!!!!
.
- Follow-Ups:
- Re: HELP !! Running SQL 2000 using ADO command object from Access 2000
- From: Sylvain Lafontaine
- Re: HELP !! Running SQL 2000 using ADO command object from Access 2000
- Prev by Date: Re: Subform Subform Subform
- Next by Date: Re: HELP !! Running SQL 2000 using ADO command object from Access 2000
- Previous by thread: Indicating stored procedure progress - To Sylvaine
- Next by thread: Re: HELP !! Running SQL 2000 using ADO command object from Access 2000
- Index(es):