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
can any one say that where we can download the QTP trail version ??????????
What is 'sleep' in sync point?
how to i add the values using the check points property?( i.e valid data(for valid data it's giving the footer message:value is added) and for invalid data: special chars, spaces,Duplicates and null values (in my page when ever we enter special chars, spaces and null values, it's giving the proper warning message and for Duplicates it's giving the footer message:"value already exists)?
Explain about the quicktest professional (qtp) automation object model?
Suppose I want fail that check point? How can you do that?
In qtp, how you can use xpath to identify objects?
What r the different filters in defect in quality center
what are all the fileds present in object repository?
hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?
after click on compose mail how can we attached a file in qtp with vbscript code
I recorded a Web App with a Oracle backend using QTP 9.5 and for some reason the scripts don't play back> What am I missing at this point. I recorded the same Apps under Sybase and they work great. This is Oracle 10g. Why won't my scripts play back.
What are the different kinds of test steps?
Hi, Can anyone please tell me how to connect the QC with QTP using QTP script? Thanks in advance
Have you used xml check point in your project? How?
Explain process of smart Identification in QTP?