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
What are the different types of recovery operation?
Explain the difference between call to action and copy action?
What is the significance of “action 0” in qtp?
how to acess a test in RSA?
How to add object to object repository in qtp9.0 Suppose for brower yahoo home page
Can you list some technologies that support qtp?
how will you check how many members visited the website www.infosys.com?
In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field and so on. how we can handle this scenerio thru Descriptive programming?
you are recording on "WINDOW 1", say it has a link if you click on that, that leads you to "WINDOW 2". If you do any manipulations on "WINDOW 2" that are automatically updated in to "WINDOW 1". But "WINDOW 1" is currently invisible. But the updations in "WINDOW 1" must also be recorded as a script in QTP. The best Example is if you update your resume in JOB STREET portal it actually happens in other window, but the previous window is automatically updated. Now does QTP help you in this types of situations? Any body can answer this question. please..... Siva
What is the quicktest professional testing process?
How to capture all the data of a webtable, weblist and combolist using QTP?
How do you perform Regreession Testing?
write script for bitmap image?
How to use Environment parameterization? Explain with an example.
What is object spy in quicktest professional?