Hi,



I'm writing a Data Access Component DAC (or DAL as it is called within Wrox

Professional ADO.NET), using the Sql Provider for .NET, that will run

within the COM+ environment - ie it is a ServicedComponent.  The idea is

that COM+ will maintain a pool of objects so that many server components

can access different databases simultaneously.

At present, it has one writeonly property, the connection string, and one

method ExecuteQuery which accepts a SqlCommand and returns a DataSet.  The

DAC component creates the appropriate SqlConnection and assigns it to the

command to be executed.  Simple enough!

However, at the point where the connection is assigned, i get the following

error: "This remoting proxy has no channel sink which means either the

server has no registered server channels that are listening, or this

application has no suitable client channel to talk to the server."  (No

connection is assigned to the command at the point of creation, before it

is passed to the DAC object)

I realise that isn't strictly an ADO problem, that the answer lies within

COM+ somewhere.  But does anyone know why this happens, and it can be

overcome?

Thanks in advance, Joe