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 to connect to oracle(sqlserver) database to QTP

Answers were Sorted based on User's Feedback



How to connect to oracle(sqlserver) database to QTP..

Answer / madhumitha

we can connect to oracle database throught conntection
string....
code for connecting to db

set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Recordset");
con.ConnectionString="DRIVER={oracle in orahome92};SERVER=
(servername);UID=(username);PWD=(password);DBQ=dbserver"
con.open
query="select * from tablename"
rs.open query,con
while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
wend
rs.close
con.close
set rs=nothing
set con=nothing

any coments always welcome

Is This Answer Correct ?    7 Yes 0 No

How to connect to oracle(sqlserver) database to QTP..

Answer / raghavan

by odbc connection using DSN

Is This Answer Correct ?    2 Yes 0 No

How to connect to oracle(sqlserver) database to QTP..

Answer / adarsh (saama technologies)

set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Resultset");
con.open"provider=oraoledb.1;server=
(servername);UID=(username);PWD=(password);DB=dbserver"
rs.open query,con
Do while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
loop
rs.close
con.close
set rs=nothing
set con=nothing

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More QTP Interview Questions

Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

0 Answers  


How do you open adobe acrobat file in QTP and do some testing on that file ?

0 Answers  


Can any one tell me how to write a script for selecting open option in File menu of A word document.here you have to add objects to OR.try like that and give me the ans.i asked this question to so many but no one knows.if any one know the answer plz let me know

0 Answers  


Define Error Pane of UFT?

0 Answers  


1 Folders in VSS 2 In navigation script there are 100 script i want to run first 50 and 37th script also not needed to run how to do this 3 What is navigation script,Driver script, business script what we are loaded in this script 4 use of resource tab 5 Difference between verification and validation give real scenario example 6 file scripting object when to use it 7 what are the problems you are faced while testing web application 8 difference between expert view and keyword view 9 difference between QTP 8.2 and QTP 9.2 navigation frame work please answer these questions from real time working people as early as possible

0 Answers  


Whether qtp 9.0 supports Test director8.0

0 Answers   TCS,


WHAT IS OBJECT REPROSITORY?

4 Answers   BirlaSoft,


What is diff. between ordinal identifier INDEX and Location?

3 Answers  


For an application we automated QTP scripts. At the same time new requirement comes for a new module for the same application and its already developed. So how we automated now this new module with the old application(using old QTP script).

2 Answers   Bosch,


Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searching a field in the datatable

3 Answers   HP,


What are the environment variables?

3 Answers  


What is the Diff between Image check-point and Bit map Check point?

3 Answers   Ordain Solutions,


Categories