Problem passing a Connection between objects

Hi All,
I'm trying to open an ADODB::Connection in a ActiveX object implemented in VB6 and pass a reference of that connection to another ActiveX object in al differente dll.
I don't know what's going wrong but I have an error when I try to set that connection as a recordset's activeConnection.
Does anyone have any clue about this problem?
Thanks in advance,
Julio

[Reznor_X]

I've tryed the same thing, it seems that you can't pass open connections between exe->dll...
you need to open the connection from your dll instead.

That is not exactly the case. You can pass an open connection and use the execute method to create a recordset. The problem with this is that you cannot specify some recodset properties like lockType.

What I don't understand is why you can pass an adodb.connection between objects and use the execute method but you cannot set this connection as the recordset's activeConnection.

Sometimes this is a very importan feature, e.g., when you need to perform some queries within an open transaction.

Regards,
Julio.

[Spectre]

The previous post isn't exactly correct either. You cannot use the execute method of a connection or recordset from within a dll - use the recordset's open method to run your queries.

This is the scenario I've tried:
One application creates and open a ADODB.Connection. The same app creates an object implemented in a differente DLL and passes a connection's reference to the new object.
The results I've got are:
1.- I can call execute method and get a recordset (with the limitation I mentioned in a previous message)
2.- When I try to set that connection as the recordset's activeConnection (modifing that property or as the argument of the open method) I get an error.
If anyone has differente results, let me know them to investigate a little further.
Regards,
Julio.