write progamming connecting QTP to database sql? this is
question asked by interview? pls any answer this?
Answer Posted / raj
objConnect=CreateObject("ADODB.Connection")
objRecordSet=CreateObject("ADODB.RecordSet")
strConnection="Driver=SQL
Server","Server=LocalSQLServerName","Database=master","UID=s
a","PWD=sa"
objConnect.OPEN strConnection
strQuery= "select * from master"
objRecordset.Open strquery, objConnect
Thanks,
Raj
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
wht type of User defined functions or Java Releated functions do we write in VB scripting
what are the utilities and drivers
How many types of recording modes in qtp? Describe each type with an example where we use them?
What are the types of object repositories? Which one is you using?
How to creating an output value using quicktest professional (qtp)?
If created one virtual object? Next time I changed the window position will it work?
WHAT IS THE DIFFERENCE BETWEEN QTP SCRIPT AND VB SCRIPT? HOW MUCH PERCENTAGE WE USE IN QTP SCRIPT REAL TIME AND HOW MUCH PERCEN OF VB SCRIPT,,,,,,,
How many ways we can parameterize data in quicktest professional?
Shall we add Local Repository to shared object repository,if yes,how we add
What is test object model in quicktest professional (qtp)?
Does Low-level recording capture mouse movements?
What is synchronization point in QTP?
Hi, is it possible for recording shortcut key during record session? The application on which I am working is web based application. This application has several shortcut key associated with menu option. I have succesfully recorded all menu option but unable to record shortcut key.
Please guide me release notes of Automation once scripts are completed
What is the extension of the qtp local repository? If it is .mtr then what is .bdb extension stands for?