ADODC disconnect, clean up
Posted on 2003-03-20
I am writing a program in VB and am using a lot of ADODC components in my windows. I am not hardcoding any connection strings etc, but directly connecting the ADODC with my grids, fields and so on.
1.My question would be, does ADODC close its connection to the database ( I have a remote Oracle server and am using ADO, Oracle OLEDB Provider) automaticaly? If not, what it seams to be the case, how do I close the connection?
2. Does VB clean up the memory (ADODC) after I close the the window with unload me, but stay in program that is running, or do I have to manually clean up. If manually, how would I do that?
I try doing this : set Adodc1.recordset.activeconnection = nothing
For some ADODC's I get an error, for others it works!
Please help, its urgent but I have no points! :)