write progamming connecting QTP to database sql? this is question asked by int

write progamming connecting QTP to database sql? this is
question asked by interview? pls any answer this?

Question Posted / nagapawan

4 Answers
7831 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write progamming connecting QTP to database sql? this is question asked by interview? pls any answ..

Answer / nagapawan

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

nagapawan

Is This Answer Correct ?

0 Yes

0 No

write progamming connecting QTP to database sql? this is question asked by interview? pls any answ..

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

Is This Answer Correct ?

0 Yes

0 No

write progamming connecting QTP to database sql? this is question asked by interview? pls any answ..

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

Is This Answer Correct ?

0 Yes

1 No

write progamming connecting QTP to database sql? this is question asked by interview? pls any answ..

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer