1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

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

Question Posted / mohit

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

action contains public and private functions but do we resuable that action or not..If it is reusable How..plz tell me the ans

1714

suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?

1404

What is expert view in qtp?

687

What are the advantages of parameterization ?

694

Hi, I am using OutputCheckPoint and I am storing the value in the data table. The stored value for column:bedroom:"Bed:4" The another value for column:bathroom:"Bath:2 Full,1 Partial" I need only the no 4 from the first column. I need only the no 2,1 from the second column. I used split array,but it also show array(0) has the value"bed:4" ..... Even though I highlight only 4,It is seleting the full value "bed 4".How can I get only the nos Thank you Uma

1377




I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?

1662

Explain the types of object repositorys in qtp?

659

how to acess a test in RSA?

1768

Hi Friends... By using QTP , can we test .net products...and that product supports different languages.. thanx in advance..

4297

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?

634

In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?

1543

How to get Traceability matrix from TD?

769

Have you done batch testing in qtp? If yes how you are doing?

594

How to add object to object repository in qtp9.0 Suppose for brower yahoo home page

1521

Brief the process of testing with UFT?

721