Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How is a Step generator used in UFT?

1208


The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)

3256


How to save your test using quicktest professional (qtp)?

1099


Give the syntax to import/export xls into qtp.

1042


Where we can use the analog mode and where we can use the low – level mode?

988


Can we call qtp test from another test using scripting. Suppose there are 4 tests and I want to call these tests in a main script. Is this possible in qtp?

1088


What are the views available in quicktest professional (qtp)?

1045


In qtp, explain what is keyword driven automation framework?

1047


How can I use Call dlls in QTP ?

2308


What is synchronization? What are the ways you can synchronize?

1154


If you are testing a web application then what will you test in that application?

2032


What is the file extension of the code file and object repository file in QTP?

1093


What is the extension of the qtp local repository? If it is .mtr then what is .bdb extension stands for?

1037


What environment does qtp run in?

1106


How often were they executed?

2454