Internal 500 error accessing DSN

Hello all, I'm trying to get data from a database (system DSN via a COM
object) through an ASP page. When I load the page, I get Internal Server
Error (500) in the browser, and when I look in the logs, I see this:

800a0e78 Operation is not allowed when the object is closed.

I looked it up and saw an article referring to Stored Proceedures (which the
database does have) but I don't know where to start to find out where the
problem lies.

Chris
Tue Aug 12 00:31:05 CDT 2003

Hello ~

This error occurs because the object you are attempting to use is closed. I
do not have your COM code, but simply start looking for areas where you are
doing a create object...

I assume you are using Visual Studio - thus I would step-through your code
to see how the variables are created and objects as well.

If you turn off friendly HTTP error messages, you would probably get more
out of the error. Also, disable On Error Resume Next in your ASP code.

Here is code that repro's this problem pretty easy... (in VBScript)

<%

dim oRs, sql, oConn

set oConn = Server.CreateObject("ADODB.Connection")
' oConn.open "MyConnStr" == NOTICE this COMMENTED OUT

set oRs = Server.CreateObject("ADODB.Recordset")
oRs.Open oConn,sql,3,1
%>

This occurs because I am attempting to open a recordset using a Conn object
that has never been opened or was previously closed...

Hope this helps,
"Angel" <angelohl@hotmail.com> wrote in message
news:OsYP$fGYDHA.2020@TK2MSFTNGP10.phx.gbl...
> Hello all, I'm trying to get data from a database (system DSN via a COM
> object) through an ASP page. When I load the page, I get Internal Server
> Error (500) in the browser, and when I look in the logs, I see this:
>
> 800a0e78 Operation is not allowed when the object is closed.
>
> I looked it up and saw an article referring to Stored Proceedures (which
the
> database does have) but I don't know where to start to find out where the
> problem lies.
>
>

Tom
Tue Aug 12 07:30:05 CDT 2003

"Angel" <angelohl@hotmail.com> wrote in message
news:OsYP$fGYDHA.2020@TK2MSFTNGP10.phx.gbl...
> Hello all, I'm trying to get data from a database (system DSN via a COM
> object) through an ASP page. When I load the page, I get Internal Server
> Error (500) in the browser, and when I look in the logs, I see this:
>
> 800a0e78 Operation is not allowed when the object is closed.

First of all, fix IE so you get a better error message with a line number.
http://www.aspfaq.com/show.asp?id=2109

> I looked it up and saw an article referring to Stored Proceedures (which
the
> database does have) but I don't know where to start to find out where the
> problem lies.

try this: http://www.aspfaq.com/show.asp?id=2307

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

Angel
Tue Aug 12 12:53:45 CDT 2003

Now we're getting somewhere - thanks guys. I changed the options in IE and
now I see the error and line # from the calling ASP page:

ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/ValidateLogin.asp, line 11

---
Line 11 in the page reads:

set x = oSQL.Login(Request.Form.Item("txtPinNumber"),
Request.Form.Item("txtSSN"))

I also looked into the stored proc on the database and saw one that was
editable, and I put the SET NOCOUNT ON in it and retried but got the same
results. :-(
The funny thing is, this site works on another server so I'm not sure whats
wrong as both the same steps were taken on both servers.


"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bhamhn$1kj8@kcweb01.netnews.att.com...
> "Angel" <angelohl@hotmail.com> wrote in message
> news:OsYP$fGYDHA.2020@TK2MSFTNGP10.phx.gbl...
> > Hello all, I'm trying to get data from a database (system DSN via a COM
> > object) through an ASP page. When I load the page, I get Internal Server
> > Error (500) in the browser, and when I look in the logs, I see this:
> >
> > 800a0e78 Operation is not allowed when the object is closed.
>
> First of all, fix IE so you get a better error message with a line number.
> http://www.aspfaq.com/show.asp?id=2109
>
> > I looked it up and saw an article referring to Stored Proceedures (which
> the
> > database does have) but I don't know where to start to find out where
the
> > problem lies.
>
> try this: http://www.aspfaq.com/show.asp?id=2307
>
> --
> Tom Kaminski IIS MVP
> http://www.iistoolshed.com/ - tools, scripts, and utilities for running
IIS
> http://mvp.support.microsoft.com/
> http://www.microsoft.com/windowsserver2003/community/centers/iis/
>
>
>

Chris
Tue Aug 12 19:36:33 CDT 2003

Hey ~

Tell me what oSQL is? Is this a COM object? Is this some other object
being substantiated using script?

--
~Chris (MSFT)
IIS Supportability Lead

This posting is provided "AS IS" with no warranties, and confers no rights


"Angel" <angelohl@hotmail.com> wrote in message
news:uKBBrqPYDHA.1736@TK2MSFTNGP10.phx.gbl...
> Now we're getting somewhere - thanks guys. I changed the options in IE and
> now I see the error and line # from the calling ASP page:
>
> ADODB.Recordset error '800a0e78'
> Operation is not allowed when the object is closed.
> /ValidateLogin.asp, line 11
>
> ---
> Line 11 in the page reads:
>
> set x = oSQL.Login(Request.Form.Item("txtPinNumber"),
> Request.Form.Item("txtSSN"))
>
> I also looked into the stored proc on the database and saw one that was
> editable, and I put the SET NOCOUNT ON in it and retried but got the same
> results. :-(
> The funny thing is, this site works on another server so I'm not sure
whats
> wrong as both the same steps were taken on both servers.
>
>
> "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
> news:bhamhn$1kj8@kcweb01.netnews.att.com...
> > "Angel" <angelohl@hotmail.com> wrote in message
> > news:OsYP$fGYDHA.2020@TK2MSFTNGP10.phx.gbl...
> > > Hello all, I'm trying to get data from a database (system DSN via a
COM
> > > object) through an ASP page. When I load the page, I get Internal
Server
> > > Error (500) in the browser, and when I look in the logs, I see this:
> > >
> > > 800a0e78 Operation is not allowed when the object is closed.
> >
> > First of all, fix IE so you get a better error message with a line
number.
> > http://www.aspfaq.com/show.asp?id=2109
> >
> > > I looked it up and saw an article referring to Stored Proceedures
(which
> > the
> > > database does have) but I don't know where to start to find out where
> the
> > > problem lies.
> >
> > try this: http://www.aspfaq.com/show.asp?id=2307
> >
> > --
> > Tom Kaminski IIS MVP
> > http://www.iistoolshed.com/ - tools, scripts, and utilities for running
> IIS
> > http://mvp.support.microsoft.com/
> > http://www.microsoft.com/windowsserver2003/community/centers/iis/
> >
> >
> >
>
>