Timeout in ADP but not in QA

[Rajat]

Hi,

I have a stored proc that times out when run through the
ADP but not when run through Query Analyzer.

How can I fix this?

Thanks,

Rajat

 

[Mary Chipman]

Create a Profiler trace and examine the call that Access is making
when it executes the stored procedure.

--Mary

 

[Jacek Segit]

Witaj Rajat,
W Twoim liœcie datowanym 27 lipca 2004 (04:50:03) mo¿na przeczytaæ:


R> I have a stored proc that times out when run through the
R> ADP but not when run through Query Analyzer.

Try change value of timeout
Tools->Options->Advanced

Regards
Jacek Segit

 

[Malcolm Cook]

Rajat,

Try this:

With New ADODB.Command
.ActiveConnection = CurrentProject.Connection ' cnx
.CommandTimeout = 0 ' no timeout!
.CommandType = adCmdStoredProc
.CommandText = <stored_proc_name>
.Execute , Array(<param1>, <param2> ), adExecuteNoRecords
End With