Pass-Through Query time-out

  • Thread starter Thread starter Jez
  • Start date Start date
J

Jez

Hi-

I have an Access 2000 front end on an SQL 2000 SP3 backend and am tring to
run a particular pass-through query as follows:

exec sp_Trades '04-Oct-2003','04-Nov-2003','XXX%',NULL,'S', 0, 256,'BBG;WM'

This query times-out no matter what timeout value I set but if I run the
exact same query in SQL 2000 Query Analyser it returns as expected in about
3 seconds.

I have other Pass-Through queries that call other sp's in my database and
they run fine.

Any ideas?

Thanks in Advance,

Jez.
 
Jez

Although not entirely similar I did have a pass through query that Access
insisted had a syntax error, yet copy and paste into the Query Analyser ,
and it ran fine. I seem to recall that I had to put some brackets round
multiple AND OR's in the WHERE clause before it would run. It could be that
"pass through" may not be a totally correct description of the activity.

Peter
 
Back
Top