DIM ADDCON DIM RECSET SET ADDDCON = CREATEOBJECT("ADODB.CONNECTION

how i will connect oracle or microsoft acess database
through manually written Script

Question Posted / sashikanth

2 Answers
6176 Views
Aurigo, I also Faced
E-Mail Answers

Answer Posted / sashikanth

DIM ADDCON
DIM RECSET

SET ADDDCON = CREATEOBJECT("ADODB.CONNECTION")
ADDCON.OPEN "DSN= ;UID= ;PWD= ;"
SET RECSET = ADDCON.EXECUTE("SELECT.....)
WHILE RECSET.EOF
.........
.........
WEND
SET ADDCON = NOTHING
SET RECSET = NOTHING

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference btn risks & Therads in the Test plan documentation?

1585

Why to use descriptive programming?

561

How to creating an output value using quicktest professional (qtp)?

566

How to use reporter.report event in qtp ?

551

How can I open a EXCEL file from QTP Resultviewer with reporter.ReportEvent function call. Example: Test files for details click "here". And clicking "Here" in the resultviewer will open a local EXCEL FILE.

1808

how to write the descriptive programming in QTP for remove the object value and substitute, with a variable then call the validation from excel

1901

What are the views available in quicktest professional?

557

how will you check how many members visited the website www.infosys.com?

1476

UFT 12.02 which ALM version will support

980

How to modify object property in qtp ?

555

What is the difference between QTP and WinRunner? Why do you choose only QTP for automation among remaing tools like Rational robot and silk test? Write the VBscript for any functionality in your project ? What is the cost of QTP ? If you entered into yahoo mail with your valid user name then you will get FOR EXAMPLE , " welcome to krishna " on the top of inbo page , how can you test it in QTP? What type of testing you can do, when we gave you 5 screens and how can you test that application? What type of framework you are using in your company and explain it?

1789

What is parameter in qtp?

676

How to create a standard checkpoint ?

555

Hi Frenz... I would like to take up the QTP certification . Can anyone tell me what is the procedure. n if anybody have the study materials pls fwd it to jkpunathil@gmail.com

1494

Hi, can explain the draw back of manual testing.plz send me the answer to my mail id deepthip1985@gmail.com

1409