adspace
How to connect to oracle(sqlserver) database to QTP
Answer Posted / adarsh (saama technologies)
set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Resultset");
con.open"provider=oraoledb.1;server=
(servername);UID=(username);PWD=(password);DB=dbserver"
rs.open query,con
Do while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
loop
rs.close
con.close
set rs=nothing
set con=nothing
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
When to use shared and local object repository?
How are actions and functions different in QTP?
How to give a call to another action from one action?
any body can you help me what is the script to automate an comand promt
Can you brief the hurdles you faced during Automation testing?
how to use the regular expression for the below code-- swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:56" There is a tree view window of the folder's ie Medication- >Pharmacy(sub folder)with 56 as count of records...The records can be different or if no records present in the specific folder..then it show "Paharmacy:-no records".Whe i record at the first time .....and try to rerun the same script with different records count say "pharmacy:800"..qtp is not regnizing it...therefore i want to user regular expression..but donot now how to use it and where to use...i have tried.... swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:\*"..but it s of no use..plz help..me
can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process
Define Environment Variable in UFT and its uses?
What is the new version of qtp which is recently released in the market?
we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?
Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar
HOw to add the recovery file at runtime to the test file .
how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods
hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.
what kind of frame work you used in your last project?