How can you connect the database with QTP?
Answers were Sorted based on User's Feedback
Answer / siva
set mycon = CreateObject("ADODB.Connection")
mycon.open("driver=SQL Server;Server=localhost;database=(database name);trusted_connection=yes")
set myresult=mycon.execute(Select * from emp)
while myresult.EOF<>TRUE
msgbox.myresult.fields(0)
myresult.movenext
wend
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prashanth
Hi Sandeep,
What are the steps through database wizanrd, will u give
clear steps.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to resume the second iteration in the QTP,, if the error has intrupted the the second iteration. When i use run from step it starting from the first iteration again.
1.How to record ,capture and also script to capture the close buttons. 2.How to record ,capture and also script to capture the options ---File ->save and File ->close in a browser and PDF files. 3.How to compare the Excel sheet values in a report using QTP scripting. 4.How to compare 2 PDf reports using QTP scripts as well reording. 5.How to compare 2 Excel reports using QTP scripts as well reording. 6.How to save a PDF report to a folder and then translate the report to an Excel type of report and compare that Excel Report with an other excel report. Please clarify me
Explain how qtp identifies objects?
How to replay a script in qtp?
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
4. what is the use of Text output value in Qtp?
HoW to open QTP in Real time.after getting the qtp window how to log in .pl answer real time people
Howcan you differentiate between Exist statement, Exist property, and Exist method??? How they used???
Associated files in QTP?
waht is the diff b/w Environment variable and Global variable in qtp?? explain types of variable in qtp??
What is the maximum size of Object Repository in QTP 8.2?
what is meant by automation tool?