I use an asp function to create a fabricated  recordset (which takes its
data from a HTML <TABLE> and its fields collection from an array).

If I check the object returned by the function in my asp page, it works fine
(I have access to its properties and collections).

But when I pass it as a parameter to a VB component (declared as "byval
vrstData as ADODB.Recordset") it fails returning the following error code:

0x80040E1D

My application is running on Win2K server and IIS 5.0

TIA,
        Ricardo

See if this KB article applies...

INFO: Passing ADO Recordsets in Visual Basic Procedures
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q193871

--
Michael Harris
Microsoft.MVP.Scripting
Seattle WA US
--

Controls on a web page run in process, correct?

Bill Wallace

See if this KB article applies...

INFO: Passing ADO Recordsets in Visual Basic Procedures
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q193871

--
Michael Harris
Microsoft.MVP.Scripting
Seattle WA US
--

Are you using AX controls and ADO on the client side or the server side?  Server side they can run in-proc or out-of-proc depending on the "Application Protection" setting in IIS 5. "Low" is in-proc, "medium" (the default) is out-of-proc (a dllhost.exe process) and "pooled" is out-of-proc (from a dllhost.exe pool).  In-proc components aren't recommended since they put the IIS process at risk if the component takes a hard crash.

--
Michael Harris
Microsoft.MVP.Scripting
Seattle WA US
--

Im using AX and ADO on the server side. The following is a code fragment
taken from the troubling asp page:

    ' Create a fabricated recordset from a posted HTML table and an array
containing names to populate the recordset's fields collection
    set rstMyRst = ssfrstCargarTabla("tblPaises", _
                                                        array("CODE,
"DESCRIPTION"))

    ' Call my bussiness object, passing the fabricated recordset just
created as one of the parameters
    Set objMyObject = Server.CreateObject("MyComponent.MyClass")

    objMyObject.MyMethod rstMyRst, _
                                            another_param, _
                                            another_param

    Set objMyObject = Nothing

The interesting thing is that if a take another recordset previously created
through a SQL Server 2000 query - and stored in the SESSION() object - it
works fine.

Thanks,
            Ricardo

Are you using AX controls and ADO on the client side or the server side?
Server side they can run in-proc or out-of-proc depending on the
"Application Protection" setting in IIS 5. "Low" is in-proc, "medium" (the
default) is out-of-proc (a dllhost.exe process) and "pooled" is out-of-proc
(from a dllhost.exe pool).  In-proc components aren't recommended since they
put the IIS process at risk if the component takes a hard crash.

--
Michael Harris
Microsoft.MVP.Scripting
Seattle WA US
--

A google search (both web abd groups) for 80040E1D does turn up a few hits related to disconnected recordsets and passing out=of-proc.  You might want to look them over.

--
Michael Harris
Microsoft.MVP.Scripting
Seattle WA US
--

What type of recordset is this?

ADODB.Recordset or ADOR.Recordset or DAO.Recordset?

ADODB.Recordset has worked in all case for me (and I have whanged them all
over the place - even into MSMQ Messages to a remote client and back again).

I'll try to drag a recordset creation sample up from the depths of my VB if
I can (may be on Tuesday).

Chris Barber.

A google search (both web abd groups) for 80040E1D does turn up a few hits
related to disconnected recordsets and passing out=of-proc.  You might want
to look them over.

--
Michael Harris
Microsoft.MVP.Scripting
Seattle WA US
--

Quick suggestion, may not be of any use but seemed to solve a similar
problem I had.
RS.MoveFirst. My setup didn't seem to like me moving recordsets until I
reset the pointer.

Im using a disconnected ADO 2.6 Recordset object (as in the rest of my
3-tier web application).

Note: Gavin Cox suggested to force a MoveFirst before passing the rst, but
that wont work if the rst has no records (as its quite possible in some
situations in my app)

Thanks,
        Ricardo