I have an update statement that gives me a time out error in VB, but not
when I run it in Query Analyzer.  I put in code to write the sql statement
to a text file right before the execute line, so I have the exact query.  I
open Query Analyzer, log in using the same credentials the VB app is using,
set context to the same database the VB app is using, and run the query.  It
takes 0 seconds to run in Query Analyzer, as I would expect.

I'm using that same connection object for several more update statements.
If I comment out the one in question, they all run fine.  If I uncomment it,
it times out.

I've no clue.

Nevermind.  I'm not paying attention.

I was calling this routine from a routine which was locking the record I was
trying to update.  I moved the call to this routine down to after the lock
is released, and it works fine.

Glad you found the resolution to your problem!

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.