Thanks for the idea, Victor. My code does set the cursorlocation property
before the open. I've also tried setting the recordset cursorlocation prior
to opening the recordset. In all cases the code freezes when this query is
> Hi Art, change the CursorLocation property before open a conecction or
> CursorLocation property of recordset.
> Vctor Koch From Argentina.
> > I'm having a strange problem with CursorLocation. I have a query that
> > against SQL Server 2000 produces a small recordset (less than 10
> > It works great with the default cursorlocation (serverside) but if I
> > the cursorlocation to clientside
> > the query just hangs, never returning a recordset and never erroring
> > Has anyone seen behavior like this?
> > Art