How to connect to oracle(sqlserver) database to QTP

Answer Posted / adarsh (saama technologies)

set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Resultset");
con.open"provider=oraoledb.1;server=
(servername);UID=(username);PWD=(password);DB=dbserver"
rs.open query,con
Do while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
loop
rs.close
con.close
set rs=nothing
set con=nothing

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between test object and run time object?

786


In qtp, explain what is crypt object

831


tell me abt a time when u had to go above &beyind the call of duty to get the job done

1688


Explain quicktest professional testing process?

748


after initiating one project for testing, when exacltly QTP tester role starts?

1683


how to find that tools work well with your existing system?

1649


With what extension you can save the list of tests in a file to run in test batch runner?

783


How to create Reusable and Multiple Actions?

1941


What is the difference between run time object and test object in QTP?

815


Is it possible to switch between recording modes during a test creation?

821


In QTP TEST DIRECTOR COMBINATION WHAT IS THE PURPOSE OF TEST DIRECTOR? In Somebody says to store test cases and design test cases.?ok fine , but In test director 5.0 , QTp not launching. what u do?

1732


please give me the code for doing retesting of gmail login page using functions so the function has to give the value

1780


Do you know how to connect database? Can you tell me the procedures?

770


Hi iam shankar here, right now iam working on manual testing. i want to switch over automation tool qtp, right now iam taking training class outside on qtp, please let me know the cost of QTP tool for full version, wether it's an annual subscription or monthly subscription.

1969


What is accessibility check point?

878