Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how we connect oracle or sql data server database to qtp.

Answer Posted / mohit

You may try:

Dim rs,sq,pkey
set conn=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
' Oracle client is required to be installed on your box
conn.open= "Provider=OraOLEDB.Oracle.1;Password=***;Persist
Security Info=True;User ID=****;SERVER=****;Data
Source=****;DBQ=****;"
sql="your sql"
rs.open sql,conn

rs.close
set rs=nothing

conn.close
set conn=nothing

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you to script when objects are removed from application?

1033


When ‘option explicit’ keyword is used in qtp?

1222


i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji

2058


How to remove the associated function library?

956


Plz Explain AUTOMATION REFERENCE MODEL?

2167


How to create a standard checkpoint ?

1018


How to start recording using quicktest professional?

1120


What are the various types of Actions in UFT?

1020


How to data driven test for Win objects in QTP ?

1893


what is the difference between modular framework & datadriven framework

2040


What is the significance of “action 0” in qtp?

994


who QTP recognizes the object stored in object repository?

2051


How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality?

1124


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

1824


what are the limitations of smart identification in qtp 9.0

2329