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
How to analyzing test results using quicktest professional?
How can i check items sorted or not in a weblist ? Give me the script for this...
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.
What is parameter in qtp?
in my application,validation message has in japanise language.how to validate this message is appears properly or not
What is an object repository?
How you will rate urself in QTP in the range of 0 to 5
What is different command used in command Prompt while using QTP?
in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?
Hi I know two types of testing processes. 1. Reaquirments stage,test design,code review's, Design review's, Test Plan, Test Cases design, test execution, Defect Reporting and tracking, UAT, Signoff. 2.Test Initiation , Test Plan, Test Design, Execution,Bug tracking, UAT, Sign off.
What is the architecture of your project? Can any one answer for this question plz........
What are the different properties of an web object
What contains Data Driven Framework document in qtp?
Does QTP record on Objects created on XWindows Environment?
How to customize qtp?