write progamming connecting QTP to database sql? this is
question asked by interview? please give sql, pl/sql related
answer?pls any answer this?

Answer Posted / rangarao

Set myconn=CreateObject("ADODB.Connectionn")
myconn.Open
("Provider=OraOLEDB.Oracle;DataSource=Your_Oracle_Database;o
SAuthent=1;")
if(myconn.state=1) Then
Set rec=myconn.Execute("query")
while rec.EOF<>TRUE
msgbox rec.fields(colname)(We can also Specify column index)
rec.MoveNext
wend
End if
rec.Close
myconn.Close

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Client is able to provide budget..he want you to choose the automation tool for the web application? which one you will select ? QTP or Selenium ? what are the reasons?

1229


please any one can explain the keyword driven framework. with gmail example.

1629


What is a quick test professional?

633


Explain different recording modes?

585


What is action? How many types of actions are there in qtp?

614






Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

1603


How to create scenario selector

1483


How to create Reusable and Multiple Actions?

1713


how to evalute defects in QTP script?

1490


How will you test a keyboard?

601


What is action split and the purpose of using this in qtp?

537


How does qtp identify the object in the application?

539


How QTP support all types of applications (platforms)?

4081


How do you create regression test packs?

610


How to write business scripts using object repository with different scenarios

1389