How to connect to the Database from QTP?
Answer Posted / murali raju
Through scripting this is way to connect the database
Example:-
set conn=Createobject("ADODB.Connection")
Srvname="Driver={Microsoft ODBC for
Oracle}:Server=DBserver,UID=Sa,Password=sa"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="select * from Users"
Rec.open SQL ,conn
Username=Rec.fields("employee name")
Msgbox Username
| Is This Answer Correct ? | 86 Yes | 20 No |
Post New Answer View All Answers
how to test Web application using QTP software
What is the parameterization?
Explain in brief about the qtp automation object model (aom).
How to handle dynamic objects in quicktest professional (qtp)?
Explain how Selenium is different from UFT?
hi i want license key for qtp 9.2 pls its adjust product name : quick test professional locking code :8 - 54A6A license type : seat license maintenance number : 88888888-8888 pls send license key to my email id borusu.ramkumar@gmail.com
Explain step generator in qtp?
In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field will reflects and so on.if total psngrs=100 then will we capture all the fields for the psngrs to Automate the app how we can handle this scenerio thru Descriptive programming?
please post the interview questions for QA position in FACTSET
How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?
How to do the scripting. Are there any inbuilt functions in QTP? What is the difference between them? How to handle script issues?
Tell me about qtp?
What is action?
i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.
What are the Test design techniques you uses in ur project?