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

where exactly we can't do the automation testing. give some examples

2 Answers   Virtusa, Wipro,

---

What do you to script when objects are removed from application?

0 Answers  

---

Object repositories types, which and when to use?

0 Answers  

---

In 1st screen,if v enter a/c no. in one field, the information of the subscriber will be displayed. The details should be displayed only in screen 3(NOTE:details should not display in screen 2).How can v do using QTP.

2 Answers   BirlaSoft, TCS,

---

How do you do batch testing in wr and is it possible to do in qtp, if so explain?

0 Answers  

---

What the differences are and best practical application of each.

1 Answers  

---

in a web page hoe to check the dynamic links that rechabging with out using regular expressions

0 Answers   CTS,

---

what are the disadvantages of descriptiveprograming

5 Answers   GE,

---

What are the key points to create a framework in QTP for oracle forms?

0 Answers  

---

How can we retrieve the Bug Ids which are open&Reopen in status through QTP scrit?Please find the script which i tried... Dim objBugFactory, objBug Dim BugId Set TDConnection = QCUtil.TDConnection Set objBug = TDConnection.BugFactory If QCUtil.IsConnected then Reporter.ReportEvent 0, "Connected", "Connected to server: " + QCUtil.TDConnection.ServerName + chr (13) +"Project: " + QCUtil.TDConnection.ProjectName + chr (13) + "Domain: " + QCUtil.TDConnection.DomainName Reporter.ReportEvent 0, "Current time on server is","==>" & TDConnection.ServerTime Else Reporter.ReportEvent 1, "Not connected", "Not connected to Quality Center" End If If mybug.Status="Open" Then BugId=mybug.DefectId MsgBox BugId End If 'OR**********************************--------------------- -----********************************** If Bug_Fields("BG_STATUS").Value ="Open" Or "Re Open"Then BugId=Bug_Fields("BG_BUG_ID").Value MsgBox BugId End If

0 Answers   TCS,

---

It seems Interview questions from Ordain Solutions are almost BASIC LEVEL-Easy. I am asking one tough question..(I think.. May be easy for some people) In recorded script the - WebLink("cityinfo") In reality, the WebLink name is "generalinfo" How you can write function to click that changed web link. NOTE: This functin should work with any Dynamic text link. I will post the answer later.

8 Answers  

---

How can the expected image for a bitmap checkpoint be recaptured in QTP

2 Answers   Ordain Solutions,

---