How to connect to the Database from QTP?
Answer Posted / manjula b
Set odb=createobject("ADODB.connection")
Strpath="c:usershappydesktopdesktop31database2.mdb"
Odb.connection string="provider=microsoft.jet.oledb.4.0;datasource="&strpath
Odb.open
Sql1="select *from employees"
Set orec=odb.execute(sql1)
Dountil orec.eof=true
Print orec.fields("employee name")
Orec.move next
Loop
Odb.close
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to execute a winrunner script in quicktest professional (qtp)?
Do you know how to connect database? Can you tell me the procedures?
What is the file extension of the code file in qtp?
How to add verification steps to tests?
What is the syntax to call one action in another?
can u please explain what is the exact difference between qtp8.2 and 9.0
Explain the concept of object repository?
For which type of projects the iterative model is not suitable?
can the activities of test case design be automated?
HOW AUTOMATE TEST SCRIPT ? what time it will do? after gneration of basic script or Any , Plz explain detailed?
How can you pass value one action to another action?
If u r using library files (Instead of Check Points) , How do u do bitmap check ?
Explain the checkpoint in qtp?
Can any give an example(if possible templates) how to test web application using QTP. thanks in advance
What is the significance of “action 0” in qtp?