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
What do you to script when objects are removed from application?
When ‘option explicit’ keyword is used in qtp?
i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji
How to remove the associated function library?
Plz Explain AUTOMATION REFERENCE MODEL?
How to create a standard checkpoint ?
How to start recording using quicktest professional?
What are the various types of Actions in UFT?
How to data driven test for Win objects in QTP ?
what is the difference between modular framework & datadriven framework
What is the significance of “action 0” in qtp?
who QTP recognizes the object stored in object repository?
How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality?
hi all can anyone explain how to write the code for finding the mandatory columns in table which are having (red*) (red Astrik)
what are the limitations of smart identification in qtp 9.0