SQL Server and ASP EOF/BOF problem

22 Jul 2005 12:22 PM

Derek Fisher

This is a half SQL Server and half ADO/ASP question. I have a web page that
displays a summary of records from a different table depending on what the
user selected. I have added a new table and my ASP page (which has worked
fine for 2 years) now displays an ADO error (EOF or BOF is true...)
indicating that the selected table contains no records.

Here's where the SQL Server portion of the question comes up. The table is
actually not empty - I've checked. I have made the ASP page print out the
SQL statement it is using. Executing this statement in Query Analyzer works
fine. As far as I can tell the ID I am using for the ASP page has rights to
this table - its part of the DataReader group and I've given it explicit
rights to the table in question. This ASP process works for all of the
other similar tables.

Can you think of any SQL Server related problem with rights (or anything
else) that might cause this problem for just 1 situation? I'd appreciate
your help.

22 Jul 2005 12:36 PM

Steve Kass

Derek,

It seems likely that the ASP page and Query Analyzer are not
querying the same table. They may be selecting from tables
with the same name on different servers or in different databases,
or with different owners.

Steve Kass
Drew University

Derek Fisher wrote:

Show quote

>This is a half SQL Server and half ADO/ASP question. I have a web page that
>displays a summary of records from a different table depending on what the
>user selected. I have added a new table and my ASP page (which has worked
>fine for 2 years) now displays an ADO error (EOF or BOF is true...)
>indicating that the selected table contains no records.
>
>Here's where the SQL Server portion of the question comes up. The table is
>actually not empty - I've checked. I have made the ASP page print out the
>SQL statement it is using. Executing this statement in Query Analyzer works
>fine. As far as I can tell the ID I am using for the ASP page has rights to
>this table - its part of the DataReader group and I've given it explicit
>rights to the table in question. This ASP process works for all of the
>other similar tables.
>
>Can you think of any SQL Server related problem with rights (or anything
>else) that might cause this problem for just 1 situation? I'd appreciate
>your help.
>
>

22 Jul 2005 12:40 PM

Derek Fisher

Ok, I feel dumb now. It's fixed so ignore my question. I thought I had
switched the page to a new server and I hadn't. Thanks anyway - that solved
the problem.

Show quote

"Derek Fisher" wrote:

> This is a half SQL Server and half ADO/ASP question. I have a web page that
> displays a summary of records from a different table depending on what the
> user selected. I have added a new table and my ASP page (which has worked
> fine for 2 years) now displays an ADO error (EOF or BOF is true...)
> indicating that the selected table contains no records.
>
> Here's where the SQL Server portion of the question comes up. The table is
> actually not empty - I've checked. I have made the ASP page print out the
> SQL statement it is using. Executing this statement in Query Analyzer works
> fine. As far as I can tell the ID I am using for the ASP page has rights to
> this table - its part of the DataReader group and I've given it explicit
> rights to the table in question. This ASP process works for all of the
> other similar tables.
>
> Can you think of any SQL Server related problem with rights (or anything
> else) that might cause this problem for just 1 situation? I'd appreciate
> your help.