Answer / snig

http://funandknowledge.blogspot.com/2008/03/qt.html

Answer / gms

'Declaration for SQL
Dim objConnection,objRecordset,count1

'Connecting to the database
Set objConnection = CreateObject("ADODB.Connection")

objConnection.Open "Driver={SQL Server};" & "Server=YOUR
SQL SERVER NAME;" & "Database= DB NAME;" & "UID=USERID;"
& "PWD=DB PASSWORD;"

'Running the query
sql1 = "GIVE UR QUERY HERE"
'Create record set for the query
Set objRecordset = CreateObject("ADODB.Recordset")
objRecordset.Open sql1, objConnection

As this is a Back-End process, you cannot view the result
set. so you can place the result in the datatable using the
following steps:


'Retrieving data from the database to the data table
count1 =1
While Not objRecordset.EOF
datatable.SetcurrentRow (count1)
Datatable("C",1)= objRecordset("nbr").value
objRecordset.movenext
count1 = count1+1
wend

can u write Script to do Data Driven Testing throuh Externel & internel XL Sheet

2 Answers   Relq,

---

describe some problem that u had with automation testing tool?

3 Answers  

---

How to handle the errors without using recovery scenery?

3 Answers  

---

scalability testing comes under in which tool?

4 Answers   EpuraTech,

---

What are the challenges u faced in testing with crm domain? How u overcome with?

0 Answers  

---

hi friends can any one provide me the project in qtp because i have to attend to interview within one week atleast you provide the website address which provide the qtp projects

2 Answers  

---

Explain QTP testing process?

1 Answers   Crea,

---

IF we use batch testing.the result shown for last action only.in that how can i get result for every action.

2 Answers  

---

Explain the check points in QTP?

2 Answers  

---

what type of framework u r using in ur organization

0 Answers   Wipro,

---

Count the number of radio buttons and randomly select one.

1 Answers   Deloitte,

---

Hi, i want download attached files in test plan area from QC to local drive in my system using QTP script. Please help me

3 Answers  

---