Ricardo Silva
|
| Posted: 02/27/2004, 1:13 AM |
|
Hi!
I tried to make a page with a many-to-many relations with two list, just
like the Example Pack Solution. After making the changes demanded by my
fields, tables and database connections names, I keep receiving the
following error message. Any suggestion on making the page work?
Thanks in advance....
Best regards,
Ricardo
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot
be displayed.
--------------------------------------------------------------------------
Please try the following:
a.. Click the Refresh button, or try again later.
b.. Open the localhost home page, and then look for links to the
information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------
Technical Information (for support personnel)
a.. Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/Promulgatio1/Pro_Update4_events.asp, line 26
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; FunWebProducts;
..NET CLR 1.1.4322)
c.. Page:
GET /Promulgatio1/Pro_Update4.asp?Professional_ID=1
d.. Time:
Friday, February 27, 2004, 5:09:47 PM
e.. More information:
Microsoft Support
|
|
|
 |
DonB
|
| Posted: 02/27/2004, 7:55 AM |
|
The object' status is "closed" because it failed to open - 99% of the time
I'd say this is due to a syntax error in the query. Possibly you have a
custom update, or event code doing an update, and the table or column names
are no longer correct? May also be failure to put apostrophes around
strings in the query.
--
DonB
http://www.gotodon.com/ccbth
"Ricardo Silva" <cp187a@hotmail.com> wrote in message
news:c1n1og$vg8$1@news.codecharge.com...
> Hi!
>
> I tried to make a page with a many-to-many relations with two list, just
> like the Example Pack Solution. After making the changes demanded by my
> fields, tables and database connections names, I keep receiving the
> following error message. Any suggestion on making the page work?
>
> Thanks in advance....
>
> Best regards,
> Ricardo
>
> The page cannot be displayed
> There is a problem with the page you are trying to reach and it
cannot
> be displayed.
>
> --------------------------------------------------------------------------
>
> Please try the following:
>
> a.. Click the Refresh button, or try again later.
>
> b.. Open the localhost home page, and then look for links to the
> information you want.
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> --------------------------------------------------------------------------
>
> Technical Information (for support personnel)
>
> a.. Error Type:
> ADODB.Recordset (0x800A0E78)
> Operation is not allowed when the object is closed.
> /Promulgatio1/Pro_Update4_events.asp, line 26
>
>
> b.. Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; FunWebProducts;
> .NET CLR 1.1.4322)
>
> c.. Page:
> GET /Promulgatio1/Pro_Update4.asp?Professional_ID=1
>
> d.. Time:
> Friday, February 27, 2004, 5:09:47 PM
>
>
> e.. More information:
> Microsoft Support
>
>
>
|
|
|
|
Ricardo Silva
|
| Posted: 03/03/2004, 12:33 AM |
|
Hi!
But I don't understand why. I used exactly the same code used in the example
pack solution for many-to-many relations via two list boxes. Off-course, I
changed, as I told previously, the field, tables and databases connections
names...
I really need this to work. Any more suggestions?
Thanks in advance.
Best regards,
Ricardo
"DonB" <~ccbth~@gotodon.com> wrote in message
news:c1np94$us3$1@news.codecharge.com...
> The object' status is "closed" because it failed to open - 99% of the time
> I'd say this is due to a syntax error in the query. Possibly you have a
> custom update, or event code doing an update, and the table or column
names
> are no longer correct? May also be failure to put apostrophes around
> strings in the query.
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Ricardo Silva" <cp187a@hotmail.com> wrote in message
>news:c1n1og$vg8$1@news.codecharge.com...
> > Hi!
> >
> > I tried to make a page with a many-to-many relations with two list, just
> > like the Example Pack Solution. After making the changes demanded by my
> > fields, tables and database connections names, I keep receiving the
> > following error message. Any suggestion on making the page work?
> >
> > Thanks in advance....
> >
> > Best regards,
> > Ricardo
> >
> > The page cannot be displayed
> > There is a problem with the page you are trying to reach and it
> cannot
> > be displayed.
> >
>
> --------------------------------------------------------------------------
> >
> > Please try the following:
> >
> > a.. Click the Refresh button, or try again later.
> >
> > b.. Open the localhost home page, and then look for links to the
> > information you want.
> > HTTP 500.100 - Internal Server Error - ASP error
> > Internet Information Services
> >
>
> --------------------------------------------------------------------------
> >
> > Technical Information (for support personnel)
> >
> > a.. Error Type:
> > ADODB.Recordset (0x800A0E78)
> > Operation is not allowed when the object is closed.
> > /Promulgatio1/Pro_Update4_events.asp, line 26
> >
> >
> > b.. Browser Type:
> > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0;
FunWebProducts;
> > .NET CLR 1.1.4322)
> >
> > c.. Page:
> > GET /Promulgatio1/Pro_Update4.asp?Professional_ID=1
> >
> > d.. Time:
> > Friday, February 27, 2004, 5:09:47 PM
> >
> >
> > e.. More information:
> > Microsoft Support
> >
> >
> >
>
>
|
|
|
|
DonB
|
| Posted: 03/03/2004, 7:45 AM |
|
Just a thought - did you create a new "site" within IIS or "virtual
directory"? Check the location in the IIS control panel to see if the
folder is a plain yellow one, or if it is a blue globe (site) or
folder-with-blue-globe (virtual dir).
If just the plain folder, that can throw the 500 error at you because
sessions do not get created correctly if there is no defined "applicaton"
(in the IIS terminology). The fix is to click the "Create" button so that
the application name is filled in (in which case the textbox holding it is
no longer grayed-out).
I seem to recall seeing 500 errors when I had the "isolation" setting at
medium or high and the IWAM username was misconfigured or disabled. Only
when the isolation is "low" does the web run under the IUSR username.
--
DonB
http://www.gotodon.com/ccbth
"Ricardo Silva" <cp187a@hotmail.com> wrote in message
news:c2458a$cud$1@news.codecharge.com...
> Hi!
>
> But I don't understand why. I used exactly the same code used in the
example
> pack solution for many-to-many relations via two list boxes. Off-course, I
> changed, as I told previously, the field, tables and databases connections
> names...
>
> I really need this to work. Any more suggestions?
>
> Thanks in advance.
>
> Best regards,
> Ricardo
>
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:c1np94$us3$1@news.codecharge.com...
> > The object' status is "closed" because it failed to open - 99% of the
time
> > I'd say this is due to a syntax error in the query. Possibly you have a
> > custom update, or event code doing an update, and the table or column
> names
> > are no longer correct? May also be failure to put apostrophes around
> > strings in the query.
> >
> > --
> > DonB
> >
> > http://www.gotodon.com/ccbth
> >
> >
> > "Ricardo Silva" <cp187a@hotmail.com> wrote in message
> >news:c1n1og$vg8$1@news.codecharge.com...
> > > Hi!
> > >
> > > I tried to make a page with a many-to-many relations with two list,
just
> > > like the Example Pack Solution. After making the changes demanded by
my
> > > fields, tables and database connections names, I keep receiving the
> > > following error message. Any suggestion on making the page work?
> > >
> > > Thanks in advance....
> > >
> > > Best regards,
> > > Ricardo
> > >
> > > The page cannot be displayed
> > > There is a problem with the page you are trying to reach and it
> > cannot
> > > be displayed.
> > >
> >
>
> --------------------------------------------------------------------------
> > >
> > > Please try the following:
> > >
> > > a.. Click the Refresh button, or try again later.
> > >
> > > b.. Open the localhost home page, and then look for links to
the
> > > information you want.
> > > HTTP 500.100 - Internal Server Error - ASP error
> > > Internet Information Services
> > >
> >
>
> --------------------------------------------------------------------------
> > >
> > > Technical Information (for support personnel)
> > >
> > > a.. Error Type:
> > > ADODB.Recordset (0x800A0E78)
> > > Operation is not allowed when the object is closed.
> > > /Promulgatio1/Pro_Update4_events.asp, line 26
> > >
> > >
> > > b.. Browser Type:
> > > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0;
> FunWebProducts;
> > > .NET CLR 1.1.4322)
> > >
> > > c.. Page:
> > > GET /Promulgatio1/Pro_Update4.asp?Professional_ID=1
> > >
> > > d.. Time:
> > > Friday, February 27, 2004, 5:09:47 PM
> > >
> > >
> > > e.. More information:
> > > Microsoft Support
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
