How to connect to the Database from QTP?

Answer Posted / manohar

Dim con,rs
set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Recordset")
con.provider="Microsoft.jet.oledb.4.o"
con.open"Path of the database"
rs.open "select * (table name),con

Is This Answer Correct ?    27 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect the remote desktop using QTP 9.2 explain the method or procedure?

2799


When I click on a link in web page.Link should open in new window.can anyone please let me know the script for this ---Koti

2487


Why to use descriptive programming?

561


What is the virtual object?

636


Hi,All How to create a link in excel sheet using qtp

2995






What is difference between design time and run time data table?

585


what the difference between shared repository and per action repository?

550


How smart identification works in qtp ?

574


Hi, my requirement is to make a query in SQL using QTP. And i have to get the results of that query and i have to use those results for future testing. I created a driver but i dont know the code for using this Driver. please help me by providing the solution for y requorement

1643


How does qtp recognize objects in aut?

580


Dear All , For UFT 12.02 which version QC or ALM will support ? Thanks Balaji

915


Explain the concept of how quicktest professional (qtp) identifies object?

573


What are the automation metrice in your project?

1709


How many number of actions possible in qtp?

600


Suppose I have three hyperlinks with same properties. How to solve this and what are the ways to solve this. we can solve this by using index property but what are the other ways we have have to solve this problem. Login (href: btnlogin.aspx) Login (href: Sourcelogin.aspx) Login (href: homelogin.aspx)

1548