 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / Web Services / June 2004Help with .NET web app
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? > 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.  SignatureJohn Saunders johnwsaundersiii at hotmail Thanks for the reply John. But both are using the same database for sure. Any other ideas? > > 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 [quoted text clipped - 9 lines] > 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? 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. SignatureJohn Saunders johnwsaundersiii at hotmail Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.