Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ravi
QTP supports interaction with Database using ADODB.
Set con = createobject("ADODB.Connection")
Set rs = createobject("ADODB.Recordset")
'Create DSN(DataSourceName) for your database and specify
the DSN here
'You can also establish connection using Provider name
con.open "DSN=MyDsn;UID=ravi;PWD=sample123"
con.execute "Insert into emp values(2500, 'Ravi')"
'Retrieve data from database
rs.open "select * from emp", con
while not rs.eof
msgbox "ID = " & rs(0) & " Name = " & rs(1)
rs.movenext
wend
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to start recording using quicktest professional (qtp)?
What ate the Technologies supported by QTP?
What are the key points to create a framework in QTP for oracle forms?
Have you done batch testing in qtp? If yes how you are doing?
Explain the keyword driven framework for the window based application complete creation of library files,env file,test data,recovery file,excel file ,repository etc and as a test engineer how is ur approach
any body can you help me what is the script to automate an comand promt
How often were they executed?
Difference between action & Reusable action?
What are the different kinds of test steps?
In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail
What the differences are and best practical application of Object Repository?
The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)
what function you write to do database testing with the help of qtp?
Where you get the run time data table?
Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln
