Timeout in ADP but not in QA

  • Thread starter Thread starter Rajat
  • Start date Start date
R

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
 
Create a Profiler trace and examine the call that Access is making
when it executes the stored procedure.

--Mary
 
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
 
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
 
Back
Top