Connection to oracle database from vba

[ogo]

Hi all,
is there anyway to close or end object session created by OracleInProcess server.
I have created object using vba like,

'Create a reference to the OO4O dll
Set objSession = CreateObject("OracleInProcServer.XOraSession")

i know that the database connection ends when we close the excel workbook which we use to connect to database, but can we code it, so that we don't need to close workbook to end connection??

 

[Sektor]

Set objSession = Nothing

 

[ogo]

Hi Sektor , thanks for replying.
Setting objSession to nothing does not close the connection.
Once an OraDatabase object has gone out of scope and there are no references to it, the object closes automatically.
Is there anyway to end it like that??

 

[ogo]

Seems like
Set objSession = Nothing
Set objDataBase = Nothing
is working..