Connect Oracel using Connection.XML via Code
I have connection configuration file i.e. connection settings file for the database in which username, password(encrypted) and other information are vailable. It is saved from Oracle SQL Developer Tool from dev team and now we can't get the password, only we have this connection XML to connect the DB and use.
In SQL Developer, we can open the DB using this connection XML but I want to connect the DB via code. Is there anyway to connect the DB using this SQL Developer connection configuration XML file? (VBScript/VB)
Last edited by scsvel; 09-06-2013 at 06:37 AM.
Thank/Like to help others if my input helped you !!!
I am speaking for myself, not for my employer nor any one.
Here in this post java - Does anybody know what encrypting technique is JDeveloper/SQL Developer using to persist credentials? - Stack Overflow couple of solution is suggested. The first one shows how to decrypt the password (code in java but can be ported to any other language supporting DES cipher). Another one uses SQLDeveloper libraries (jar files) and suitable only for the code that is going to be executed inside JVM.