I'm trying to pass an open ADO connection object to a method in an ActiveX DLL.
As soon as I try to open a recordset using this connection in the ActiveX DLL it gives me an error 3001.
I know the connection is good as im using it in the calling procedure and when I check the status of the connection in the ActiveX DLL everything looks fine.
I could just open another connection but I would rather use the open connection if possible.
I also tried passing an ADO recordset and this works fine!!!
Ive tried setting the connection as a property, as a parameter, creating a local connection and setting it to the passed connection all to no avail.
Anyone got any ideas?