Answer / 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

Answer / m.s.patil

You can write OLEDB script:

Set Con =CreateObject("ADODB.Connection")
ConString="Provider:SQLNCLI;Server=plantdev;DataBase=QAServe
r;UID=patil;PWD=password1"
Con.ConnectionString=ConString
Con.Open

Please any on explain usage of "on error resume next","On error goto 0" with sample code....Thankyou......... when a tester is asked to execute 100 scripts in a short time..(the server will be down in another 10 min)..how he has to run those scripts?

2 Answers   Datamatics,

---

What are the automation metrice in your project?

0 Answers   Accenture,

---

How can you connect the database with QTP?

3 Answers  

---

For what purpose to we use object repository in a application?also explain usage of obj.repository?

3 Answers  

---

For which type of projects the iterative model is not suitable?

0 Answers  

---

if mandatory and Assitive propertys are shows same how will u write skript in QTP window

0 Answers   Wipro,

---

Need one Urgent help please,for ex: first time i created Local reposory and convert that local to shared Rep and save in some where(by using Export local objetcs), unfortunately that saved repository is missed, now i want same repository,but iam not able to export the same repository second time?? i need that Repository only how to get???

2 Answers   TCS,

---

distinguish between old version and new version QTP features.

0 Answers   CTA,

---

how to test load test and block box testing an a web based application pls give ans briefly

0 Answers   Impiger,

---

object types is used for what?

1 Answers  

---

How to export quicktest professional results to an .xls file?

0 Answers  

---

hi study this carefully,WHO ARE TEACHING WITH THE HELP OF FLIGHT RESERVATION WINDOW...THOSE FACULTIES ARE VERY BAD...BUT WHO ARE TELLING WITH PROJECT ORIENTED MEANS(NOT FR WINDOW) DIRECTLY OPEN THE BANK WEB PAGES OR ANY OTHER REAL TIME WEB PAGES... BASED ON THAT WEB PAGES, FACULTY TEACH, IN THIS WEB PAGE WHEN UR USING QTP , WHEN UR USING MANUAL... WHERE UR WRITING THE SCRIPTS FOR THIS WEB PAGE.. .LIKE THIS ................THIS IS THE TEACHING FORMAT FOR QTP... 1ST U FIND OUT WHO IS FOLLOWING THIS TYPE OF FORMAT THOSE PEOPLES ARE .BEST FACULTIES AND JOIN THAT INST. THIS IS 100 % TRUEEEEEEEEEEEEE REMEMBER IT........ NOW ONWADS U HATE FLIGHT RESERVATION WINDOW ONLY REAL TIME WEB PAGES........... THAN KU

1 Answers  

---