how i will connect oracle or microsoft acess database
through manually written Script
Answer Posted / baba fakruddin
'This is for Microsoft Access
dim con,rs
set con=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
con.provider="microsoft.jet.oledb.4.0"
con.open "d:\testdata.mdb"
rs.open "select * from emp",con
do while not rs.eof
vbwindow("form1").vbedit("val1").set rs.fields("v1")
vbwindow("form1").vbedit("val2").set rs.fields("v2")
vbwindow("form1").vbbutton("validate").click
rs.movenext
Loop
' Oracle Connection
con.open
"provider=oraoledb.1;server=localhost;uid=scott;pwd=tiger;datbase=testdata"
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Why do we use breakpoints in QTP?
What is a reusable action?
How to open a new test using quicktest professional (qtp)?
What is the latest version of qtp?
How to handle dynamic objects in quicktest professional (qtp)?
What is the extension of the qtp local repository?
i'm testing the webpage with QTP, in this wabpage i have to choose the CV from the window, but QTP can't recognize the object, so i used the Low LEvel Recording, but every time i run the test, QTP go to halt when it gets to the Recorded part, any solution for that?( except puting delay in the script and manuall selecting, because i've did that)
How do you synchronization point through DP?
Pls can anyone give me the entire code for the Keyword driven framework with respect to he Flight Reservation Window in detail with explanation. Pls explain in detail stepwise. Thanks a lot. Pls very urgent?.
Can we Test Welcome Screens and Process Images with QTP
Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in
How do you perform Regreession Testing?
How to save your test using quicktest professional (qtp)?
what r the main attributes of test automation?
Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri