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
How to start recording using quicktest professional?
On what document base Descriptive programming is written if build is not yet ready ?
Explain how Does Run time data (Parameterization) is handled in QTP?
what is the difference between modular framework & datadriven framework
What is fragmentation and paging?
I want to grow as a Automation Engineer,Kindly help me in clearing my interview that what interviewer looks for as a Automation Engineer. I am having three years of experience in testing.
Explain how qtp identifies object?
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com
How to associate shared object repository to test in qtp?
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
Your roles and responsibilities and daily tasks? (As automation tester)
When Recovery scenario actually starts while testing the application?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?
Hi Friends, Would be great if you can provide the Model Question paper, Web site link or any reference s. Thanks & Regards, Byzoor,