I want to disconnect from an Oracle database so I can connect with another user & password -same dsn - but VB seems to keep the old connection and doesnt change to the new use/passw.. anyone has done this before?
Thanks in advance!
Printable View
I want to disconnect from an Oracle database so I can connect with another user & password -same dsn - but VB seems to keep the old connection and doesnt change to the new use/passw.. anyone has done this before?
Thanks in advance!
Do you close Database and all Recordset objects this way:
rs1.Close
set rs = nothing
rs2.Close
set rs2 =nothing
'.
'.
db.Close
set db = nothing
This steps should kill your current connection and clear memory
Vlad