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 |
when I was doing the web testing with QTP using with standard checkpoint the Object selection -checkpoint properties dialog box not displaying pages and links hierarchical order. Could you please tell me. thanks
Hi All, I have a problem with getting the value which is available in the table and it is not having any unique property. Please find the below table TopicName CreatedBy ViewCount ------------------------------------------------ XXXX Y 10 ZZZZ ZZ 0 AAAA BBB 3 In the Above table TopicNames are link and it is having an id but the remainig two columns(Created by and ViewCount) are static Web element values and they are not having any unique property. Now i want to get the values of Created BY and View count for each and every topic. Can anybody give me the solution for the above ASAP. If anybody didn't understand the above please free to send me a mail by that i can send you the snap shots and some more description. You can catch me at krishnachand.p@gmail.com
supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?
Hello, I am facing problem to check textpoint for mercury application . I have inserted checkpoint to check flight summary for place of departure and arrival with datatable and script look like "Browser("Find a Flight: Mercury").Page("Book a Flight: Mercury").Check CheckPoint("Book a Flight: Mercury_4")" but while I am executing this script at last my check point gets fail and display Text Checkpoint: captured "" between Summary and 4/31/2008FLIGHT , expected "Acapulco" Match case: ON Exact match: OFF Ignore spaces: ON I think value from data table is not fatched so please guide me what I have to do to overcome this problem.. Thanks
Hi Friends, Iam Beginner in QTP and i want to Try the software QTP. I checked the mercury site for QTP Trial version and i found QTP 9.0. The thing is that it supports windows 2000,Xp but not windows 98.And Iam using Windows 98 onlu and it's not possible for me to upgrade to windows 2000. Pls. guide me how to get the trial version of QTP which supports windows 98 Operating System The version may be 6.5 is ok for me.Thanks in Advance
What are the data types in qtp?
how can we preform retesting(DATA driven test) using function please gine the code for loginpage
Describe the process for writing text check point for a web application?
how qtp will recognise if application is run on many browsers
How to take screenshots in qtp?
i can done the project with QTP in that time i can say how many members in my team size?
is it possible to map an image as standard Object or u've to treat as virtual? how to map an Dynamic image into standard object?