> How about
> .ActiveConnection = adoConnection
> ?
That solved my problem. Thank you Hiroshi, Andrea and others for your help.
I *really* appreciate it. Plus I learned a lot in the process. Thanks,
once again.
From the MSDN about ActiveConnection.
You can set this property to a valid Connection object or to a valid
connection string. In this case, the provider creates a new Connection
object using this definition and opens the connection.
Regards,
Mike Miller
Application Software Developer,
School Of Physical Education,
University Of Otago,
+64 3 479 9123
http://physed.otago.ac.nz