How to connect to the Database from QTP?

Answer Posted / surendra adapa

For Sql-Server:
"provider=SQLOLEDB;Server=servername;Databae=dbname;Userid= ;Password= :"
or
"provider=SQLOLEDB;Server=servername;Databae=dbname;Trusted-Connection=yes;" (windows Authentication)

For MS-Access:
"provider=Microsoft.Jet.OLEDB.4.0;DataSoure=Path;uid= ;pwd= ;"

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle the exceptions using the recovery scenario manager in qtp?

562


What is reusable action?

591


What the differences are and best practical application of Object Repository?

581


Where should i find checkpoint and virtual objects's Object properties and values in the QTP 9.2 Means where checkpoints or virtual objects related data will store If i want to get the runtime object properties how can i use Getroproperties on Checkpoints

1449


How to use output values in qtp ?

548






What are the advantages of qtp?

574


What are the different types of recovery operation?

545


hi all can anyone explain how to write the code for finding the mandatory columns in table which are having (red*) (red Astrik)

1392


What is the expert view?

545


Can I change properties of a test object?

610


hi nani my doubt is how does qtp process metrix related to software process.

1540


What is throw Object?

1542


Explain data driven framework?

571


How to check feasibility of the appliction?in automation testing?

1465


What are the two types of repositories available, explain them?

586