G
Guest
I am displaying a form with a datagrid populated from a select of database
records which now exceed 12,000 when I select them all.
The form displays just fine with all 12,000+ entries but when I leave the
form to go back to the originating program, I get a "The page cannot be
displayed" screen for "Cannot find server or DNS error" "Internet Explorer".
But when I select a lesser number of records - under 12,000 (don't think
there is anything sacred about 12,000 - that could vary based on the amount
of data fields in each line), when I leave the form to go back to the
originating program, the originating screen comes back just fine.
I have been told there is no limit in the size of a datagrid or the overall
form. (Thanks Anders)
I have all been told that I am probably getting an exception in my ASP.NET
application which results in an HTTP error. I was told to switch off
friendly HTTP error message in Tools > Internet Options > Advanced by
unchecking the "Show friendly HTTP error message" option in the Browsing
option group. I would then be able to see this error. (Thanks Anders)
I did that but still doesn't work. I still get the "The page cannot be
displayed" screen. I don't see any error by switching "friendly" off.
I tried another approach in my development environment (Professional 2002)
to locate the source of the problem as follows:
In my development environment, there is a difference in what is displayed.
Under 12,000 no problem. Over 12,000 returns a "Enter Network Password"
dialog box with "Please type your username and password". Then clicking on
OK gets you the "The page cannot be displayed" screen. However clicking on
Cancel gets you a "You are not authorized to view this page" screen (do not
get this in live environment). On this page by clicking on a Microsoft
Support link, you get to a page that says "Error Message: 401 Error
(Unauthorized: Login Failed)". The resolution stated to fix this is:
1. Open the Local Security Policy tool from the Administrative Tools
folder.
2. Select Local Policies, choose User Rights Assignments, and then click
the Log on Locally user right.
Did this - still get the same two pages. "The page cannot be displayed" or
the "You are not authorized" after getting the "Enter Network password"
dialog box.
I then added a Try Catch block to my code to encase the Response.Redirect to
the originating program.
In the Xcp.Message, I get "Thread was being aborted", the program still
redirects back to the originating program for under 12,000 records but
produces the "Enter Net Password" dialog box I described above for over
12,000 records.
records which now exceed 12,000 when I select them all.
The form displays just fine with all 12,000+ entries but when I leave the
form to go back to the originating program, I get a "The page cannot be
displayed" screen for "Cannot find server or DNS error" "Internet Explorer".
But when I select a lesser number of records - under 12,000 (don't think
there is anything sacred about 12,000 - that could vary based on the amount
of data fields in each line), when I leave the form to go back to the
originating program, the originating screen comes back just fine.
I have been told there is no limit in the size of a datagrid or the overall
form. (Thanks Anders)
I have all been told that I am probably getting an exception in my ASP.NET
application which results in an HTTP error. I was told to switch off
friendly HTTP error message in Tools > Internet Options > Advanced by
unchecking the "Show friendly HTTP error message" option in the Browsing
option group. I would then be able to see this error. (Thanks Anders)
I did that but still doesn't work. I still get the "The page cannot be
displayed" screen. I don't see any error by switching "friendly" off.
I tried another approach in my development environment (Professional 2002)
to locate the source of the problem as follows:
In my development environment, there is a difference in what is displayed.
Under 12,000 no problem. Over 12,000 returns a "Enter Network Password"
dialog box with "Please type your username and password". Then clicking on
OK gets you the "The page cannot be displayed" screen. However clicking on
Cancel gets you a "You are not authorized to view this page" screen (do not
get this in live environment). On this page by clicking on a Microsoft
Support link, you get to a page that says "Error Message: 401 Error
(Unauthorized: Login Failed)". The resolution stated to fix this is:
1. Open the Local Security Policy tool from the Administrative Tools
folder.
2. Select Local Policies, choose User Rights Assignments, and then click
the Log on Locally user right.
Did this - still get the same two pages. "The page cannot be displayed" or
the "You are not authorized" after getting the "Enter Network password"
dialog box.
I then added a Try Catch block to my code to encase the Response.Redirect to
the originating program.
In the Xcp.Message, I get "Thread was being aborted", the program still
redirects back to the originating program for under 12,000 records but
produces the "Enter Net Password" dialog box I described above for over
12,000 records.