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

how can we merge the object repositories?is ther any option in qtp to merge the object repositories if we have two or three object repositories?

6 Answers   IBM,

---

How Qtp will identifies object during run time

6 Answers   CSS Corp, Yahoo,

---

how to find that tools work well with ur existing system?

0 Answers  

---

Browser("Las Vegas Hotels - Las").Page("Vegas Hotels - Hotels").Link("Luxor") ......here Luxor is a hotel and this is recognised as a link. I have many hotels like Luxor, Palms etc which are all displayed as link...How do I parametrize this by using webtable functions??? ASAP

1 Answers   HP,

---

How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one

0 Answers   Livetek,

---

how we connect oracle or sql data server database to qtp.

4 Answers   TCS,

---

What is vulnerability?

1 Answers   CTS,

---

what is the use of automation frame work ??(QTP)

2 Answers  

---

How can we count the no of rows are available in a data table ?

9 Answers   Kanbay,

---

what is verification & validation?

2 Answers   Accenture, TCS,

---

1)What is the Difference Between WaitTo & Sync?

4 Answers   Wipro,

---

What are the three challenges U faced during automation testing of your application.

2 Answers   L&T,

---