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
how to test use the quality control .how to verify the image verification
What is data driver in qtp?
What is Cross browser testing? Does UFT support it?
How to find array size in qtp?
Discuss quicktest professional environment?
In the application that I'm testing is having a WYSIWIYG editor.QTP is recording editor's body as web element. I want to add some data to this web Element at run time. The problem is that I cant find a method to add contents to this web Element. Can any one come up with an answer for this. Thankx.
Hi All, How to Compare two strings character by character in QTP
How does you test a weblink which is changing dynamically?
What are the main differences of qtp and win runner?
Please guide me release notes of Automation once scripts are completed
What is the purpose of loading qtp add-ins?
Explain different types of checkpoints?
i'm using the qtp to test to vb appliction,i wanted to get the new application's title.i didn't want to use the winAPI to get it ,i 'd like to know whether a QTP function can do it. Eg: SystemUtil.Run "C:\Program Files\.....","","","" 'run an application, and misure the application is activating,then how to get the hwn wihtout using windowns api
How can you pass value one action to another action?
if mandatory and Assitive propertys are shows same how will u write skript in QTP window