how we connect oracle or sql data server database to qtp.
- 4 Answers
- 28812 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the methods of the TextStream object that are used for reading from a text file?
What is the use of "New Property" in "Add properties" of testobject properties in object repository. How can i use "New properties" while writing scripts if i have assign some values to the testobject properties Can anyone help me? plz
What is difference between shared and local object repository?
what is supply chain management?
regular expression in qtp standar check point for months from accepting months from january to december only
What are the Test design techniques you uses in ur project?
What is the extension of qtp local repository?
How you can decide which type of object repository you have to use?
What is the difference between rational rose and QTP?
what is meant by Implicit and explicit requirements?
Explain the features and benefits of quick test pro(qtp)?
Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?
I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me
How to write business scripts using object repository with different scenarios
Through array we can execute the testcase how ? give me example
