How to connect to the Database from QTP?
Answer Posted / sandipgami84
Dim ObjCon, ObjResult, ObjSQL
set ObjCon=Createobject("ADODB.Connection")
ObjCon.ConnectionString("DSN= ,UID= ,PWD= ")
ObjSQL="SELECT * FROM Emp"
ObjCon.Open()
ObjResult=ObjCon.Execute(ObjSQL)
ObjCon.Close()
ObjResult=Nothing
whtever ur data stored in ObjResult variable
| Is This Answer Correct ? | 31 Yes | 13 No |
Post New Answer View All Answers
Explain different types of checkpoints?
Explain QTP using different development techniques ?
Which scripting language used by quicktest professional?
What are the different types of checkpoints?
What are the key points to create a framework in QTP for oracle forms?
Can we run test with out adding object in object repository? How it is possible?
what frame work you are following?
Explain how Does Run time data (Parameterization) is handled in QTP?
what r the verstions from 1st to present (verstions) of mercury tools (like winrunner,QTP,Loadrunner) ? Chandana
How to use debug tools?
How to handle dynamic objects in quicktest professional (qtp)?
Hi, I am using OutputCheckPoint and I am storing the value in the data table. The stored value for column:bedroom:"Bed:4" The another value for column:bathroom:"Bath:2 Full,1 Partial" I need only the no 4 from the first column. I need only the no 2,1 from the second column. I used split array,but it also show array(0) has the value"bed:4" ..... Even though I highlight only 4,It is seleting the full value "bed 4".How can I get only the nos Thank you Uma
is it possible to add sheets to excel at runtime
What is standalone database?
How to associate function library at a run time?