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

i need qtp tutorial. pls send it to sridhar.k151@g mail.com

1871


how to write xml output check point bu useing descriptive programing .means without useing output check point

1870


Can you list some technologies that support qtp?

754


could any help me please, how to work on visual foxpro application using UFT

2038


"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...

1700


There is an built in window application in qtp9.1,i.e.Flight4.0.i want to implement the recovery maneger on it.How can i do this?

1826


what type of run time errors you get while you ar edoing rpg program?

1708


What are metrics and matrix?

1556


With what extension you can save the list of tests in a file to run in test batch runner?

774


What is difference between design time and run time data table?

829


What are the ordinal identifiers in web page?

849


What is action?

783


when I was doing the web testing with QTP using with standard checkpoint the Object selection -checkpoint properties dialog box not displaying pages and links hierarchical order. Could you please tell me. thanks

1984


Analyzing the checpoint results?

794


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

1686