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 execute the WR Script through QTP? I have WinRunner script with initialization script, common scripts, GUI AND functions. I connected WR through QTP with "call to WinRunner" option but I am getting problem after connecting to WinRunner i.e. showing "Do you want to quit now" with 'yes' and 'No' message box
What is quick test pro? What is a quick test professional?
What is the Difference between test object and run time object?
how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page
To which environments does quicktest professional (qtp) supports?
i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression
For which type of projects the iterative model is not suitable?
What is qtpro? What is quick test pro? What is a quick test professional?
how to disable the pop ups through QTP using a script
supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?
unique properties of button,edit box, radio button,check box?
What processes will be required to manage updates to the web site's content, and what are the requirements for maintaining, tracking, and controlling page content, graphics, links, etc.?
Explain about the test fusion report of quicktest professional?
when to start the automation?
can the activities of test case design be automated?