write progamming connecting QTP to database sql? this is
question asked by interview? pls any answer this?
Answer Posted / prathyusha
set odb=createobject("adodb.connection")
odb.connectionstring="provider=sqloledb;server=zz;database=xx;user
name=xy;password=as"
(if we want to work with sql database then we can go for sqloledb provider)
odb.open
if odb.state="1" then
msgbox "connected to database"
else
msgbox "not connected to database"
end if
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
when to start the automation?
How do you check ticket cost and ticket number in flight application?
How to interact tool & application build in QTP?
What is ObjectParamater?
How can I change object description or check point values in qtp?
How to use parameterization in qtp?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What is the difference between them? How to handle script issues?
Dear All, How to generate Pass or Fail Report in QTP without using Reporter.Report Event Method ? Thanks Balaji
Have you used xml check point in your project? How?
What is TOM in QTP?
What is the basic concept of qtp?
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,,,,,,,
Explain about Test Fusion Report of QTP?
Hi All, I need code for how to execute qtp scripts from excell sheet
Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.