DB Access Component

[Syed Khan]

Hi,

Can i have the Connection object being passed as the parameter from the Component(Dll) i am using to connect to the databaese to the ASP page.

Thanks.

Syed Khan

[Bob Barrows [MVP]]

Syed Khan wrote:

> Hi,
>
> Can i have the Connection object being passed as the parameter from
> the Component(Dll) i am using to connect to the databaese to the ASP
> page.
>
> Thanks.
>
> Syed Khan

No, connections cannot be marshalled across processes. Connection strings
can.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Syed Khan]

Thanks Bob, can u please let me know if is it possible at Recordset Level. If
not what will be the best approach around this?

Regards,
Syed Khan

"Bob Barrows [MVP]" wrote:

> Syed Khan wrote:

> > Hi,
> >
> > Can i have the Connection object being passed as the parameter from
> > the Component(Dll) i am using to connect to the databaese to the ASP
> > page.
> >
> > Thanks.
> >
> > Syed Khan

> No, connections cannot be marshalled across processes. Connection strings
> can.
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
>

[Bob Barrows [MVP]]

While disconnected recordsets can be marshalled, it is better to use variant
arrays (using GetRows) or xml documents. I don't have time to go into a
major explanation of these right now, but you can use Google to find a lot
of information on these topics.

Bob Barrows
Syed Khan wrote:

> Thanks Bob, can u please let me know if is it possible at Recordset
> Level. If not what will be the best approach around this?
>
> Regards,
> Syed Khan
>
> "Bob Barrows [MVP]" wrote:
>

>> Syed Khan wrote:

>>> Hi,
>>>
>>> Can i have the Connection object being passed as the parameter from
>>> the Component(Dll) i am using to connect to the databaese to the ASP
>>> page.
>>>
>>> Thanks.
>>>
>>> Syed Khan

>> No, connections cannot be marshalled across processes. Connection
>> strings can.
>>
>> Bob Barrows
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get
>> a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"