Help with .NET web app

[MS]

I have developed an asp.net application which is running on different
machines. Now the issue is, I am generating a report. Here when I generate
thsi report on a remote machine, it shows only 1400 records, whereas when I
try the same on the machine wher the database is located (SQL 2000), then it
gives full 5400 records. What am I missing?

[John Saunders]

"MS" <an*******@discussions.com> wrote in message
news:uk**************@TK2MSFTNGP09.phx.gbl...

I have developed an asp.net application which is running on different
machines. Now the issue is, I am generating a report. Here when I generate
thsi report on a remote machine, it shows only 1400 records, whereas when I try the same on the machine wher the database is located (SQL 2000), then it gives full 5400 records. What am I missing?

This problem is likely to be application-specific, so much more detail would
be required in order to answer the question.
A first guess would be that the remote machine isn't accessing the same
database or the same server as the machine where the database is located.
--
John Saunders
johnwsaundersiii at hotmail

[MS]

Thanks for the reply John.
But both are using the same database for sure.
Any other ideas?
"John Saunders" <jo**************@notcoldmail.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

"MS" <an*******@discussions.com> wrote in message
news:uk**************@TK2MSFTNGP09.phx.gbl...

I have developed an asp.net application which is running on different
machines. Now the issue is, I am generating a report. Here when I generate thsi report on a remote machine, it shows only 1400 records, whereas

when I

try the same on the machine wher the database is located (SQL 2000),

then it

gives full 5400 records. What am I missing?
This problem is likely to be application-specific, so much more detail

would be required in order to answer the question.
A first guess would be that the remote machine isn't accessing the same
database or the same server as the machine where the database is located.
--
John Saunders
johnwsaundersiii at hotmail

[John Saunders]

"MS" <an*******@discussions.com> wrote in message
news:es*************@TK2MSFTNGP11.phx.gbl...

Thanks for the reply John.
But both are using the same database for sure.
Any other ideas?

Well, I have an idea, but I'm a bit concerned that my idea will sound like
an insult. It's not, really. It's the same advice I'd give to myself under
the same circumstances.

Make damned sure that it's the same database, on the same server, running
the same query and/or stored procedure, logged in as the same user.

Also, try simplifying the situation by removing the query from the reporting
code. Even if all you do is a Response.Write of the row count, that will
help to confirm that you're talking to the same place. You may also want to
dump out the details of the Connection object.
--
John Saunders
johnwsaundersiii at hotmail