How to connect to the Database from QTP?

Answer Posted / murali raju

Microsoft ADO (ActiveX Data Objects) is a Component object
model object for accessing data sources.The ADO Recordset
object is used to hold a set of records from a database
table. A Recordset object consist of records and columns
(fields).
In ADO, this object is the most important and the one used
most often to manipulate data from a database.

Srvname is a connection string.if u already installed
oracle in your system..using that path u can connect oracle
database...if u dont have oracle give the conncetion string
path..whatever connection string created used in database
checkpoint by
default...Example:DSN=QT_Flight32;DBQ=C:\Program
Files\Mercury Interactive\QuickTest
Professional\samples\flight\app\flight32.mdb;Driver=C:\WINDO
WS\system32\odbcjt32.dll;DriverId=281;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;

Is This Answer Correct ?    39 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different attribute used with regular expression?

531


What is the difference between the design-time and run-time data tables?

552


i have asked earlier only one question how to test web application using QTp plz send me the answer quickly

1655


Hi ,Can any one pleas explain how to test splash objects using QTP?

1903


hi guys we r working in office...we write some scripts..suddenly we have a work(5min only) in out side..what will do now,,,used to system shut down or log off or lock or sleep mode,switch use or hibernate?

1584






What are the different types of recording modes?

529


what is actually contain test report? can anybody post the test report

1470


Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar

2794


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?

527


What are the differences between quicktest professional and winrunner?

536


What is the expert view?

547


How many ways we can parameterize data in quicktest professional (qtp)?

581


Which recording modes need more memory?

576


Hi,Sudhanandareddy plz forword framework and ppts for QTP to me. This is my mail id: ranjith_99reddy@yahoo.co.in (your contact number also)

1735


How to use the object spy in quicktest professional (qtp) 8.0 version?

509