How to establish oracle DB connection using lr_db_connect function

[Prasad Chandanala]

Hi,

I tried using the lr_db_connection to establish the connection to oracle databse but I'm getting the Connection failed {"ORA-12560: TNS:protocol adapter error"} error message. Below is the systax is used to connect to DB

lr_db_connect("StepName=Connect", "ConnectionString=Provider=OraOLEDB.Oracle.1; Persist Security Info=True; DSN=testdata;UID=XXXXX;PWD=XXXXXX", "ConnectionName=XXXX", "ConnectionType=OLEDB", LAST );   

Any help would be appreciated.

Thanks and Regards,

Prasad.