I came across the following error when trying to establish a connection with my database: -
ORA-12540 TNS:Internal Limit Restriction Exceeded
On re-booting my PC all was ok.
Is it possible that 0040 caused the problem?
The reason I ask is beacause I have some Excel reports that connect to the DB using 0040 and after having the error I noticed that in parts of the code I didn't have Set objOraSession = Nothing
, plus the same for the Database or Dynaset.
Would the coonection still be in the memory even after closing Excel?
Regards,
Andrew