Groups | Blog | Home
all groups > dotnet ado.net > october 2007 >

dotnet ado.net : Sporadic "Cannot find Table 0" Error


Chandrasekar
10/12/2007 7:50:18 AM
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]
10/15/2007 1:13:26 PM
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
10/24/2007 12:02:59 AM
On Oct 15, 7:13 am, "Cor Ligthert [MVP]" <notmyfirstn...@planet.nl>
[quoted text, click to view]

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
AddThis Social Bookmark Button