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 data base?

Answers were Sorted based on User's Feedback



How to connect to data base?..

Answer / ravi

QTP supports interaction with Database using ADODB.

Set con = createobject("ADODB.Connection")
Set rs = createobject("ADODB.Recordset")

'Create DSN(DataSourceName) for your database and specify
the DSN here
'You can also establish connection using Provider name

con.open "DSN=MyDsn;UID=ravi;PWD=sample123"

con.execute "Insert into emp values(2500, 'Ravi')"

'Retrieve data from database
rs.open "select * from emp", con
while not rs.eof
msgbox "ID = " & rs(0) & " Name = " & rs(1)
rs.movenext
wend

Is This Answer Correct ?    1 Yes 0 No

How to connect to data base?..

Answer / m.s.patil

You can write OLEDB script:

Set Con =CreateObject("ADODB.Connection")
ConString="Provider:SQLNCLI;Server=plantdev;DataBase=QAServe
r;UID=patil;PWD=password1"
Con.ConnectionString=ConString
Con.Open

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More QTP Interview Questions

Hi my name is mohan. I am working as a manual tester.. And now i want learn QTP.. is there any online websites to learn QTP for free if u know any plz help me out..,.or send mail to k.mohann.mohan@gmail.com

3 Answers   Wipro,


Who is the best faculty for QTP in Hyderabad? Is it Mr. G.C.Reddy, some are referring his name?

21 Answers  


Explain xml checkpoints.

0 Answers  


How many function you use in your application?

2 Answers   Polaris,


Explain about Test Fusion Report of QTP?

0 Answers  


when you press a link it displays "the page cannot be displayed" then as a tester how you will find the problem,what type of problem must be it?

3 Answers  


What is the differnce between action & script

2 Answers   Lehman Brothers,


how you have used object libraries? plzzzzz do answer

1 Answers  


1.what is the difference between childobjects and child items in qtp? 2.what is difference between a class and function? 3.can u convert ustimings to indian timings using vbscript? 4.i have scripts in one machine.can i run those scripts in another machine.how?

2 Answers   Genpact, Infosys, Symantic Space, TCS,


tell me the script for envirnment value parameeter with an example. which situation envirnment valu parameter is used

2 Answers   HCL,


i have a window , initial its name is "NEW CUSTOMER" i have to enter the details of customer in the test object fields and after saving the window name is automatically changing with the customer name . so how to identify that window after saving. (i am using descriptive programming.)

5 Answers   Syntel,


How to add a runtime parameter to a data sheet?

6 Answers  


Categories