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
When and why to use descriptive programming?
what is the hierarchy to use properties in descriptive programming
what could go wrong with test automation?
Diff b/w test scenario's and test Procedures?
How to test background color and dynamic images during run time can you put the check point for moving objects?
what is error and fault in terms of software quality?
How you can write contexts to text file in qtp?
If a button named "CLICK" is recorded in low level recording mode , what will be the values stored for "name" property of that button in object repository ?
Limitations in QTP?
HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.
Is the qtp course will help to create a virtual object?
Please guide me release notes of Automation once scripts are completed
How can you identify the browser and its information using QTP script?
Explain the views in the QTP GUI?
What are the various types of Actions in UFT?