MarcS
Occasional Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
SLM does not release the licence anymore
The Smartbear Licence Manager does not release the Test Complete licence anymore. After the last "Check in", no "Check out" followed. Also a restart of the machine did not release the licence. First were stated: 0/1 remaining seats. But then 1/1 remaining seats. Nethertheless, I can't start Test Complete and a "Rejected" event is logged.Solved103Views2likes4CommentsRe: ADO: Connection to the database still exists, after calling connection.close (Oracle)
Hi Alex, when I connect to this user with a database tool and then close the connection, then it works correctly. So I assume it has nothing to do with the Oracle configuration, otherwise I would expect the same behavior with these tools. Maybe it has to do with ADO or TestComplete At the moment I have a good workaround, connecting with the system user. But thanks anyway for your support. Regards MarcS1.2KViews0likes0CommentsRe: ADO: Connection to the database still exists, after calling connection.close (Oracle)
Hi Alex, thank you for your reply. The hint with the garbage collection would fit with the following, which I've found out in the meantime. After a 2 minute wait, the connection is terminated. But the variable is only defined within the function. I was able to solve my problem first by using the user SYSTEM. This way I have no connection to the schema, which I first query and then possibly delete. It would be interesting to see what happens, If I could call the "collect function" of the garbage collection from TestComplete Regards MarcS1.3KViews1like2CommentsADO: Connection to the database still exists, after calling connection.close (Oracle)
If I execute the following code snipped, the user for the ADO connection is still connected to the database in the background. I'm not able to delete the database scheme for this user, after closing the connection. Oralce throws the error: ora-01940 cannot drop a user that is currently connected var QryConnection = ADO["CreateConnection"](); QryConnection["ConnectionString"] = "Data Source="+"TNSName"+";User Id="+"UID" + ";Password="+"PWD"; QryConnection["Open"](); QryConnection["Close"](); Only when my tests have been run and the execution is finished, the connection will be closed completely. In the ADO documentation I've found this: "To completely eliminate an object from memory, close the object and then set the object variable to Nothing (in Visual Basic)." I've tried to set QryConnection to undefined or null after calling close, but the connection was still available. If I execute the following query in Oracle, I can see the connection, despite calling connection.close: select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p where Upper(s.username) = 'XXX' and p.addr (+) = s.paddr; What can I do, that after closing a connection, the access to the databse will be released?Solved1.4KViews0likes5Comments