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

Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...

1600


How can I find out the cursor position through QTP suppose I am keep tabbing(Pressing the tab key continuously) and stoped at a position Now I want to find out where the cursor position is

6396


How can you write the scripts that operate on different objects depending on run-time information?

2216


Limitations in QTP?

1824


How many lines of code in each script of QTP?

4115






Hi,All How to create a link in excel sheet using qtp

3091


How many types of recording modes are there?

673


How to connect to a database?

670


How do you delete unwanted results in qtp?

710


How can you exit from an action?

692


What ate the Technologies supported by QTP?

762


What is Distributed testing? How does UFT support it?

685


How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))

1765


What are the types of object repository in qtp?

659


If I change the property value at runtime is it effect is object repository?

710