Mark
|
| Posted: 06/27/2003, 10:30 AM |
|
Any site I create with a login has this problem. I get the error
below in the common.asp. This is the line of code refered
SET connection =
Can anyone assist me with this issue?
I'm sure it is a simple fix
Thanks you
This
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 itcorpsql2 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.
/new/Common.asp, line 1455
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
c.. Page:
POST 42 bytes to /new/Login.asp
d.. POST Data:
login=admin&password=admin&DoLogin=Sign+In
e.. Time:
Friday, June 27, 2003, 10:40:15 AM
f.. More information:
Microsoft Support
|
|
|
 |
DonB
|
| Posted: 06/28/2003, 3:43 PM |
|
Not enough information to tell for sure.
I suspect that you have insufficient permission to open the database with
the webserver user context. The direct cause of the error is that the
recordset failed to open and subsequently a SELECT (or maybe INSERT/UPDATE)
failed..
Is it Access? If so, the usual problem is your webserver does not have write
access to the directory where the MDB is located.
Is it another database such as SQL Server or Oracle? Then it is probably
still permissions, but a lack of SELECT permission on the table.
When you deploy, the webserver runs under a different user context than when
you are developing the app. If it is Windows and IIS, then the
IUSR_<servername> account is the default account, and likely is not
authorized in the database (assuming SQL Server, etc.). It is possible the
IIS virtual directory where you deployed to is NOT an "application" (is
there a globe icon in the IIS manager?). Of course, you might not be
running IIS at all.
One last re-read of what you wrote makes me think maybe non-login type apps
are working, which would void what I said about database permissions, except
the possibility your "user" table has different permissions that the rest of
the tables.
Again, not enough info to diagnose.
DonB
"Mark" <marke50@yahoo.com> wrote in message
news:bdhuvs$m1p$1@news.codecharge.com...
> Any site I create with a login has this problem. I get the error
> below in the common.asp. This is the line of code refered
> SET connection =
>
>
> Can anyone assist me with this issue?
> I'm sure it is a simple fix
> Thanks you
>
> This
> 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 itcorpsql2 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.
> /new/Common.asp, line 1455
>
>
> b.. Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
>
> c.. Page:
> POST 42 bytes to /new/Login.asp
>
> d.. POST Data:
> login=admin&password=admin&DoLogin=Sign+In
>
> e.. Time:
> Friday, June 27, 2003, 10:40:15 AM
>
>
> f.. More information:
> Microsoft Support
>
>
>
>
>
|
|
|
|
|
