How do u connect database through QTP
tell me both Ms Access and SQL
Answers were Sorted based on User's Feedback
Answer / prasanth
we can connect to database in QTP using "ADODB" connection
object.
Sample code for SQL Server:
set mycon = createobject("ADODB.Connection")
mycon.open("driver=SQLserver;server=localhost;database=
(database name);trusted_connection=yes")
set myresult=mycon.execute("select * from sample")
while myresult.EOF <> TRUE
msgbox.myresult.fields(0)
myresult.movenext
Wend
you can get the connection strings
for "connectionstrings.com"
Kumar.rnv@gmail.com
Broadridge
| Is This Answer Correct ? | 8 Yes | 1 No |
Explain the Different types of QTP test assets and their extensions?
An object is created, i dont know the methods available for that object, i want to find methods available for that object and use the required method. How i can do this???
Can we use same virtual objects in many number of tests?
When u ll use Record Button in QTP?Is VB script is Mandatory in QTP? What is Meaning of Frame("v1")?
what is the difference between Automation object model(AOM) and test object model(TOM)
how u will describe testing activities?
what is the defference between calling ation and called action?
Cn u please clarify my doubt Where are micTab and micReturn used.Thanx in Advance
How can I generate customized logs in QTP ?
I have written some scripts in QTP by using older version, but I want to run them in latest version. Is there any process to do that.If so can anyone explain me?
How to save your test using quicktest professional?
What are the most frequent errors you faced while executing your scripts?