write progamming connecting QTP to database sql? this is
question asked by interview? pls any answer this?

Answer Posted / ajit

Dim cn,rs

Set cn = createboject("ADODB.CONNECTION")
Set rs = createobject("ADODB.RECORDSET")

cn.open "DSN=D1"
rs.open "select empno,empname from emp",cn

while
rs.EOF<> TRUE
print rs(empno)&" "rs(empname)
rs.movenext
wend
cn.close
rs.close

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If object is not recognized by qtp but the object is standard object what is your approach?

588


1 Folders in VSS 2 In navigation script there are 100 script i want to run first 50 and 37th script also not needed to run how to do this 3 What is navigation script,Driver script, business script what we are loaded in this script 4 use of resource tab 5 Difference between verification and validation give real scenario example 6 file scripting object when to use it 7 what are the problems you are faced while testing web application 8 difference between expert view and keyword view 9 difference between QTP 8.2 and QTP 9.2 navigation frame work please answer these questions from real time working people as early as possible

1601


what is clean sweep?

1877


Can any one say what exact diff between test->parameters, action properties-> parameters. after defining the parameters in test->settings, how can we access those parameters.(i know how to use action prop parameters)

1619


What is method name to compare two XML files.

1528






Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B

2906


how to prepared for first for the first interview?

1791


Whats the realtime QTP testing process

1989


Explain data driven framework?

572


i have a doubt can anyone tell me where are scripts stored while using QTP.Tell me the exact procedure takes place in real time?like how we call scripts how to proceed after writing scripts?how scripts are executed etc?i heard some use Qc whether others dont use.so tell me whole procedure for both the things it will be a very big help.as i have interview i want to have whole idea on this.its very urgent.

1374


If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?

579


Will there be any standards or requirements for page appearance and/or graphics throughout a site or parts of a site?

600


what is the difference betn QTP 8.0 AND PREVIOUS VERSION

1949


How many types of status are there?

582


Where can I find and view run-time data table?

517