how to connect qtp to sqlserver?(if any body know about this please send mail to me:sheik_feroz5@yahoo.com)thank u

Answer Posted / rajib

set conn=Createobject("ADODB.Connection")
Srvname="Driver=<>,Server=<>,UID=<>,Password=<>"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="<SQL statement>"
Rec.open SQL ,conn

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the concept of object repository & how qtp recognizes objects?

570


write a script to verify links on any web page by using descriptive method by creating a description object (give a filter condition only link) ... need to verify expected like name by reading

1491


How many lines of code in each script of QTP?

4036


how can i pass a "cript"as a parameter in to a function

1460


1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.

1678






Hi Friendss..., can any body help me.. 1. Tell me your achievements(Technically)..? 2. Tell me your strengths(Technically) and weakness(Technical)..? 3. Why are you looking for change..?

1420


What is the extension of the qtp local repository? If it is .mtr then what is .bdb extension stands for?

573


What is the quicktest professional (qtp) testing process?

568


Please Don't mind .i want in detail the real time process i.e in each document what it contains.

1437


what is run action?

1435


What are the Test design techniques you uses in ur project?

1487


What is meant by a Check Point in UFT? Also, explain the applicable Check Points.

705


Hello, Is there any way to send the test results in html format (or any other) by email using outlook after the test run ends? thank you in advance

1740


How to run a test using quicktest professional?

528


What is the default add-ins in qtp?

554