write a VBscript code to parametrize test script using test
data from sqlserver database?

Answer Posted / rajh

dim con,rec
set con=create object("adodb.connection")
set rec=create object("adodb.recordset")
con.open"provider=sqloledb.1;server=name;username=scott;pwd=tiger;database=dbname'
rec.open"sql statement"con
while not rec.eof
window("winmame").winedit("uname").set rs.fields(un)
in the same way use the data
loop

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?

1787


1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?

1641


Explain features of the latest version of qtp/ uft 12.1?

766


any body can you help me what is the script to automate an comand promt

2145


what is test scheduleling?

2183






Tell some commonly used Excel VBA functions?

760


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

2284


What is the basic concept of quicktest professional?

710


hi Friends ,willany body tell me what is the Scope for the automation Testing inht Future is their Or not And what is the Top Most Level in the testing section according the Pay scale

1708


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...

1673


what is the difference between the modular framework and datadriven frame work

2075


I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.

1736


Please Don't mind .i want in detail the real time process i.e in each document what it contains.

1599


Is QTP supports Unix. If yes, then how the test automation is done?

1887


how could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)

1577