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
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
While spliting an action in QTP 10.0 getting an error : "This Line is a part of Script Block.You cannot split the action on this line." how to re-solve this and split the script into actions?
How many types of parameters are available in quicktest professional (qtp)?
HOw to add the recovery file at runtime to the test file .
What is Port testing. Whhen will you perform?
Through array we can execute the testcase how ? give me example
Explain the difference between call to action and copy action?
After executing the script in qtp suppose i found some script execute successfully and found some error.So how to report the status for both (i.e pass and fail report)in test director. For "fail" We use "defect tab" in testdirector. But for "pass" how to report it to TL.what is the process plz anybody ans
Explain different types of checkpoints?
What is fragmentation and paging?
Have you used xml check point in your project? How?
To which environments does quicktest professional supports?
What is object spy in quicktest professional?
Differentiate the type of test cases which can be automated and which cannot be automated?
Describe the differences between functions and actions in UFT?