Interested to Buy Any Domain ? << Click Here >> for more details...
How to connect to oracle(sqlserver) database to QTP
- 3 Answers
- 11297 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / adarsh (saama technologies)
set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Resultset");
con.open"provider=oraoledb.1;server=
(servername);UID=(username);PWD=(password);DB=dbserver"
rs.open query,con
Do while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
loop
rs.close
con.close
set rs=nothing
set con=nothing
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Which functionalities of QTP used in banking project? pls any say answer?
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?
What are the things(properties, and other details) will be recorded while recording an object using normal recording?
How to remove associated function library?
What is use of object spy?
Where we can use the analog mode and where we can use the low – level mode?
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
To which environments does quicktest professional (qtp) supports?
What is quick test pro?
Is QTP supports Unix. If yes, then how the test automation is done?
What is contained in the object repository?
Explain the difference between check point and output value?
How will you find the current time of the remote machine using QTP script?
Will down time for server and content maintenance/upgrades be allowed? how much?
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
