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
Difference between test object and run time object?
In qtp, explain what is crypt object
tell me abt a time when u had to go above &beyind the call of duty to get the job done
Explain quicktest professional testing process?
after initiating one project for testing, when exacltly QTP tester role starts?
how to find that tools work well with your existing system?
With what extension you can save the list of tests in a file to run in test batch runner?
How to create Reusable and Multiple Actions?
What is the difference between run time object and test object in QTP?
Is it possible to switch between recording modes during a test creation?
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?
please give me the code for doing retesting of gmail login page using functions so the function has to give the value
Do you know how to connect database? Can you tell me the procedures?
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.
What is accessibility check point?