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...

write progamming connecting QTP to database sql? this is
question asked by interview? please give sql, pl/sql related
answer?pls any answer this?

Answer Posted / bharanikumar . r

Hi all,

I had some idea about this question

Answer:

First we need to create the object for connection

ie.
Set a = Createobject("ADODB.Connection")
set b = Createobject("ADODB.recordset")

Then with the help of created object we will define the SQL
Query

For ex:
Opening the data from SQL:

step 1 - create the connectivity whether manually or qtp
step 2 - a = Select * from exmployee with the connectivity
with DSN

and we have to declare the array size also because once a
data retrieved from the database it will stored in array
format --

Thank u

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

We stored into the objects OR and then write the scripting

2035


How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?

1049


Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?

1151


Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..

1822


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

2923


In qtp, how you can use xpath to identify objects?

1091


What is throw object?

2383


How can get count of list box?

1150


Explain in brief about the quicktest professional automation object model?

955


How is UFT 11.5 version different from UFT 12.0?

1071


How to do call a output parameter from one action to another action??/

2371


What processes will be required to manage updates to the web site's content, and what are the requirements for maintaining, tracking, and controlling page content, graphics, links, etc.?

1092


Whether qtp 9.0 supports Test director8.0

2583


How to get the particular property value?

1069


How to find the name of the machine where you are running your automation scripts in qtp?

1003