Re: Can I get a SqlConnection from an ADO connection?

> To solve a problem of participating in a transaction, where COM code calls
> into .NET 2.0 code, I need the .NET code to participate in the transaction
> started by the COM code.  A distributed transaction is not an option, and
> sp_bindsession is not working.

        Still a DTS transaction is what you should use, OR you should call
into your COM code from .NET code to do the sql calls from .NET. You can't
create a SqlConnection by passing in the internal connection object from the
pool.

                FB


>
>
>
> I would like, if possible, to receive an ADO connection object in my .NET
> class, somehow convert that to an ADO.NET connection object, and be done
> with minimal code changes.  However, it is not a train smash if I have to
> use ADO in my .NET code for the data retrieval.  This is my worst case, but
> only involves minor changes.  I just don't like it.
>
>
> ===================================
> This list is hosted by DevelopMentor.  http://www.develop.com
>
> View archives and manage your subscription(s) at http://discuss.develop.com

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com