Hey Guys,
We finally made it! After hours and almost days of working on this stuff!! (just kidding)
Is there any test developer position on Automated Qa?? kidding again!
Alright,
First we needed to download the driver. For some crazy reason we could not made this with Oracle nor Miscrosoft drivers. We had to download Progress DataDirect ODBC driver. Really cool!
After reading loads of websites (I was actually wondering why Test Complete does not come with a nice Oracle connection example) we finally came up with the simpliest and most useful connection query... here's the example and once again thank you so much guys for your help.
Cheers !
Jmc
Example :
function connect(){
var connectstring = "Data Source=dsnOracle;User ID=user;Password=password"; //3 params only!!!
var patientlist = ADO["CreateADOQuery"]();
patientlist["ConnectionString"] = connectstring;
patientlist["SQL"] = "Select pat_lastname FROM pat_data";
patientlist["Open"]();
patientlist["First"]();
res = patientlist["FieldByName"]("pat_lastname")["Value"];
BuiltIn["ShowMessage"](res);
}