Sporadic "Cannot find Table 0" Error

[Chandrasekar]

Our web application runs on .NET Framework 1.1.Sometimes we get errors
like
"Cannot find table 0".

After this error the whole website is non-functional. If some one
accesses the website at that instance they get the same error.

The only fix that resolves the issue is "resetting IIS".

We tried to isolate the issue but we couldn't find the source of the
issue.

If someone can shed some light on the issue it would be helpful.

 

[Cor Ligthert [MVP]]

Sporadic,

Do you have maybe selects which are dynamic and therefore can give under
certain circumstances no tables in a dataset (the first is table 0)

Cor

 

[Chandrasekar]

Sporadic,

Do you have maybe selects which are dynamic and therefore can give under
certain circumstances no tables in a dataset (the first istable0)

Cor

Hi,

The sql is pretty straight.

The db component is a static class and the db instance was getting
created in the constructor.I just made the component an instatiable
one and it seems to be working.

Any issues using static classes.Any one had issues with static classes
with respect to load.

Thanks,
Chandrasekar