MS SQL Server ODBC - More statistics

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

More statistics

Reuven Nisser

2006-01-18, 7:23 am

Hi Steven,
I have now more details regarding the problem. It seems that about 25%
of the queries fail. It's not consistent. Also, it happens during move
next after retrieval of several records successfully.

It seems the problem is related somehow to transactions. Let's think of
the theoretical aspect: What happens when you select a recordset and one
of the records inside it was changed by another process during a
transaction but the transaction did not complete yet?

It might be it, or something else like it. Am I correct to assume that
such problems might cause SQL_NO_DATA?

If it so, what should be done when I receive this error? Can I move to
the next record? Wait awhile and retry? Abort using the recordset and
generate it again?

Thanks, Reuven

Sponsored Links