Migration Error

[Mike]

Hi group,
I'm moving to a new Windows Server 2003 and IIS 6 from
Windows Server 2000 and IIS 5. I get the error below
when I access a asp page with a select statement ONLY if
the database(Access 2002) is open. My legacy server
allows the database to be open and the pages still post.
Has anyone seen this before? If so, can you point my in
the right direction on how to fix it?

P.S. All the databases are running as shared.

ADODB.Connection error '800a0e78'

Operation is not allowed when the object is closed.

[Roland Hall]

"Mike" wrote in message news:1cc6e01c45306$66a8e370$a101280a@phx.gbl...
: Hi group,
: I'm moving to a new Windows Server 2003 and IIS 6 from
: Windows Server 2000 and IIS 5. I get the error below
: when I access a asp page with a select statement ONLY if
: the database(Access 2002) is open. My legacy server
: allows the database to be open and the pages still post.
: Has anyone seen this before? If so, can you point my in
: the right direction on how to fix it?
:
: P.S. All the databases are running as shared.
:
: ADODB.Connection error '800a0e78'
:
: Operation is not allowed when the object is closed.

Mike...

Showing relevant code would be helpful...

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - [url]http://www.microsoft.com/technet/scriptcenter/[/url]
WSH 5.6 Documentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]

[IPT]

Seems to me your script try to close a recordset when it's a select
statement.

Remove script that close the recordset. Instead, use set recordset =
nothing.

You must close connection, though.

"Mike" <michael.hendricks@concrete.org> wrote in message
news:1cc6e01c45306$66a8e370$a101280a@phx.gbl...

> Hi group,
> I'm moving to a new Windows Server 2003 and IIS 6 from
> Windows Server 2000 and IIS 5. I get the error below
> when I access a asp page with a select statement ONLY if
> the database(Access 2002) is open. My legacy server
> allows the database to be open and the pages still post.
> Has anyone seen this before? If so, can you point my in
> the right direction on how to fix it?
>
> P.S. All the databases are running as shared.
>
> ADODB.Connection error '800a0e78'
>
> Operation is not allowed when the object is closed.