Help with .NET web app

  • Thread starter Thread starter MS
  • Start date Start date
M

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?
 
MS said:
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?
Click to expand...

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.
 
Thanks for the reply John.
But both are using the same database for sure.
Any other ideas?
 
MS said:
Thanks for the reply John.
But both are using the same database for sure.
Any other ideas?
Click to expand...

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.
 
Back
Top