Answer / rajib

set conn=Createobject("ADODB.Connection")
Srvname="Driver=<>,Server=<>,UID=<>,Password=<>"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="<SQL statement>"
Rec.open SQL ,conn

Answer / mahaboob

set conobj=createobject("ADODB.connection")
conobj.open.provider"providername",Datasource="path of file",uid="username",pwd="password"

Answer / sunita

Dim sServer, sConn, oConn, sDatabaseName

sDatabaseName = "Migrations"
sServer = "hyrdwsz0010"

Set oConn = CreateObject("ADODB.Connection")
oConn.Open "provider=sqloledb;data source=" & sServer & ";initial catalog=" & sDatabaseName &";Trusted_Connection=Yes;"
oConn.CommandTimeout = 0

Set oRs = oConn.Execute("Select * from dbo.CLIENTLISTSS")
Set RowCount= oConn.Execute("Select Count(*) from dbo.CLIENTLISTSS")
Msgbox FormatNumber(RowCount(0),0)
Msgbox oRs.Fields.Count
Msgbox oRs.Fields.item(1)
arraydata=oRs.GetRows
Msgbox arraydata(1,1)

what is Smart identification

1 Answers   Wipro,

---

hi i have one issue while selecting weblist i want show one particalur item in weblist .ex one weblist they are monday to sunday i want show the reporter like thurday in particular weblist can you help me about this thanks balaji

5 Answers  

---

what do u mean by test harnesses in qtp?

1 Answers   Verizon,

---

what is the difference between rational rose and QTP? WHICH TOOL IS BETTER TO LEARN? PLEASE SEND ME AT sana_50218@yahoo.com sandeep@epuratech.com

0 Answers   EpuraTech,

---

Explain me in deatail about DATADRIVEN framework including scripts ?(realtimes plz)(Chandana)

4 Answers   Wipro,

---

What are the various automation frameworks available in qtp?

0 Answers  

---

What expansion of "MIC" in MICPASS (TEST ReportPAGE)

11 Answers   TCS,

---

Hi all, can anyone tell me the challenges u faced while using qtp?

2 Answers  

---

How to find the number the number of Links, Brolken Links in a webpage?

3 Answers   Ordain Solutions,

---

Hi, this is venkatesh. Q: I have 10 files in a folder(say D:\). Out of which there are some .txt, .xls, .doc. I want to know how to get the count of each file using qtp? If U have any ans, plz write script for that...

4 Answers   EDS,

---

What is the scripting language used in QTP?

11 Answers   IBM,

---

hi guys, pls tell me for testing institution training hub, hitech city is best or not?

0 Answers  

---