Answer / prasanth

we can connect to database in QTP using "ADODB" connection
object.

Sample code for SQL Server:

set mycon = createobject("ADODB.Connection")

mycon.open("driver=SQLserver;server=localhost;database=
(database name);trusted_connection=yes")

set myresult=mycon.execute("select * from sample")

while myresult.EOF <> TRUE
msgbox.myresult.fields(0)
myresult.movenext
Wend


you can get the connection strings
for "connectionstrings.com"


Kumar.rnv@gmail.com
Broadridge

Answer / alok

Through Data Driver Wizard

I had installed QTP 9.2. It is working fine but whenever I open QTP, it is trying to reinstall the below-mentioned files again and again "QTP92PS82UPGRADE.exe", "recogn.dll". If anybody has these files, please provide those files in this site or you can send that files to my mail id also (lravi4u@yahoo.com). If you don't know where the files will be in the QTP, search in the QTP software CD or path of QTP program installed (C:\Program Files\Mercury Interactive\QuickTest Professional)

0 Answers  

---

How u call functions in QTP Function to calculate the length of characters in a wor

2 Answers  

---

what is reusable action and how the same can be implemented (process)?

2 Answers  

---

How u perform Batch Program in QTP?

3 Answers  

---

How to open a new test using QTP?

1 Answers  

---

what is meant by Implicit and explicit requirements?

0 Answers  

---

I have the script like this: Browser("Login").Page ("Application").Frame("ScopeFrame").Link("DC3701737 (Active)").Click in which the value "DC3701737" will get changed and i have to use the same value in so many places. I got the value "DC3701737" in to a variable(Say x). Now if i want to pass the variable in to link object .. how? Browser("Login").Page("Application").Frame ("ScopeFrame").Link(x).Click Is it possible to pass any variable into a link object .. so, that the application will select that link automatically? If ur not able to understand, pls let me know.

2 Answers   ABC,

---

How to use QTP for Regration testing, plz tell as with short Example of login window? plz tell as....

2 Answers  

---

what sort of things what u put in Bug Report ?

1 Answers  

---

How Can I automate PDF forms using QTP9.2 ?

0 Answers  

---

can u expect, major bugs in NET BANKING Project? Modules Transaction Module, Customer Relation Module.

2 Answers  

---

For example one window is there the window contain some of Check boxes but my question is how many check boxes are there particular window? Please solve the problem gi_raju@rediffmail.com ippaliraju@yahoo.co.in

3 Answers  

---