Answer / nagapawan

hello not for sql server, this question is asked by me in
sql , pl/sql

nagapawan

Answer / prathyusha

set odb=createobject("adodb.connection")
odb.connectionstring="provider=sqloledb;server=zz;database=xx;user
name=xy;password=as"
(if we want to work with sql database then we can go for sqloledb provider)
odb.open
if odb.state="1" then
msgbox "connected to database"
else
msgbox "not connected to database"
end if

Answer / raj

objConnect=CreateObject("ADODB.Connection")
objRecordSet=CreateObject("ADODB.RecordSet")

strConnection="Driver=SQL
Server","Server=LocalSQLServerName","Database=master","UID=s
a","PWD=sa"

objConnect.OPEN strConnection

strQuery= "select * from master"

objRecordset.Open strquery, objConnect

Thanks,
Raj

Answer / ajit

Dim cn,rs

Set cn = createboject("ADODB.CONNECTION")
Set rs = createobject("ADODB.RECORDSET")

cn.open "DSN=D1"
rs.open "select empno,empname from emp",cn

while
rs.EOF<> TRUE
print rs(empno)&" "rs(empname)
rs.movenext
wend
cn.close
rs.close

For Passing Parameters from one Action to another Action we will use Input & Output parameters. Can any one tell how to use this Input & Output parameters with Example ?

2 Answers   TCS,

---

what is TOM in qtp?

5 Answers   Accenture,

---

what is the silent mode in WR?

1 Answers  

---

Is it possible to test Flat file using QTP? I have two file- first file is Input file and second file is output file. Input file has Format like first 2 field is record type, next 10 field is Description. Output file also has format. I want to check this file format using QTP. Is it possible?? please reply with example.

2 Answers   Wipro,

---

hi i am new to qtp i need to run all files by a batch what is the procedure and what are following actions to be take?

1 Answers   ADP,

---

can we call a test in another test?

3 Answers   iFocus,

---

Explain abt the File System Object in QTP with ex

3 Answers   Ordain Solutions,

---

if there r 10 windows open in QTP write a command to close all 10 windows at a time ?

11 Answers   Wipro,

---

how to test one edit box using Java addin for Web Applications? write script?

1 Answers   IBM,

---

How can I find out whether a word in a string is existed or not for example "QTP IS A POWERFULL TOOL FOR AUTOMATION" How can i find out whether "powerfull" is existed in the above string or not Could anyone answer it?

7 Answers   Livetek,

---

what is the difference between link and hyperlink?

10 Answers   Infosys,

---

please any one can explain the keyword driven framework. with gmail example.

0 Answers  

---