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

How do you create new test sets in td?

1055

give me an example where u used good judgement and logic in solving a problem

3854

Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........

2203

How to create Reusable and Multiple Actions?

2190

What are the different attribute used with regular expression?

967

Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks

2413

hou can we use vb script in qtp could u tell me breafly

2198

What are the automation metrice in your project?

2279

How can get count of list box?

1137

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

2032

Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?

1027

how to i add the values using the check points property?( i.e valid data(for valid data it's giving the footer message:value is added) and for invalid data: special chars, spaces,Duplicates and null values (in my page when ever we enter special chars, spaces and null values, it's giving the proper warning message and for Duplicates it's giving the footer message:"value already exists)?

1894

Hi, Hope you viewers are doing fine with good health. What are the steps and connection parameters to connect to Oracle db ? Can you connect with just the Oracle client or Oracle XE ? Cheers!!

2985

hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.

2351

How does quicktest professional (qtp) identifies the object in the application?

1033