Answer / madhumitha

we can connect to oracle database throught conntection
string....
code for connecting to db

set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Recordset");
con.ConnectionString="DRIVER={oracle in orahome92};SERVER=
(servername);UID=(username);PWD=(password);DBQ=dbserver"
con.open
query="select * from tablename"
rs.open query,con
while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
wend
rs.close
con.close
set rs=nothing
set con=nothing

any coments always welcome

Answer / raghavan

by odbc connection using DSN

Answer / 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

Hi let me ask one questin 1.How to use outputof the one function input to the another function pls give the script for above 2.what is the purpose of action parameter , how to create it

2 Answers  

---

When I click on a link in web page.Link should open in new window.can anyone please let me know the script for this ---Koti

1 Answers   HCL,

---

How to read a text file from QC using QTP. I would like to do something like this. But instead read a file from QC and NOT from my local drive. Set fso = CreateObject("Scripting.FileSystemObject") Set InputFile = fso.OpenTextFile("C:\test.txt", ForReading) Thanks

1 Answers  

---

Hi All, I need code for how to execute qtp scripts from excell sheet

1 Answers  

---

Could you please suggest a book to start with QTP and also a book for advanced concepts?

2 Answers  

---

how do find current links in webpage for ex: in yahoowebsite today mainpage is having 50 links and next day same page is having 60 links. if i run same programe it should display total links in webpage ?

4 Answers   CTS,

---

How we can test a Frame in a web page?

1 Answers   eMids,

---

How many types of parameters are available in quicktest professional (qtp)?

1 Answers  

---

can the activities of test case design be automated?

1 Answers  

---

How to test whether the navigation i.e. from one page to another is working r not using QTP for web based application. plz explain in detailed or mail the sample code to malepatin@gmail.com

1 Answers  

---

How to suppress warnings from the test results page?

1 Answers  

---

Can we put more than one action in a single script???? yes or no.....

2 Answers   BirlaSoft,

---