Answer / manish deshmukh

Set con = Createobject("ADODB.Connection")
set rs = Createobject("ADODB.recordset")
con.connectionstring="DSN=xyz;UID=abc;PWD=pqr;"
con.open
SQL="select * from manish"
Set rs=con.execute(SQL)

Answer / rangarao

Set myconn=CreateObject("ADODB.Connectionn")
myconn.Open
("Provider=OraOLEDB.Oracle;DataSource=Your_Oracle_Database;o
SAuthent=1;")
if(myconn.state=1) Then
Set rec=myconn.Execute("query")
while rec.EOF<>TRUE
msgbox rec.fields(colname)(We can also Specify column index)
rec.MoveNext
wend
End if
rec.Close
myconn.Close

Answer / bharanikumar . r

Hi all,

I had some idea about this question

Answer:

First we need to create the object for connection

ie.
Set a = Createobject("ADODB.Connection")
set b = Createobject("ADODB.recordset")

Then with the help of created object we will define the SQL
Query

For ex:
Opening the data from SQL:

step 1 - create the connectivity whether manually or qtp
step 2 - a = Select * from exmployee with the connectivity
with DSN

and we have to declare the array size also because once a
data retrieved from the database it will stored in array
format --

Thank u

How do I lauch my test website using code from qtp in different environmet, uat and PPTE?

0 Answers  

---

How do u do batch testing in WR & is it possible to do in QTP, if so explain?

1 Answers   Crea,

---

i can done the project with QTP in that time i can say how many members in my team size?

0 Answers  

---

Now it appears to be more than enough... I have learn entire QTP, I did whatever I could do but still facing lots of problem and those problems could be removed only after working in professional atmosphere. But still unable to expose myself as professionaly. It is becoming panic, It has been two years I am in manual testing and looking for the change but all the recruiters ask for QTP, but my problem is I don't have working experience with QTP. Kindly suggest me I really need effective suggestions. I dont have more caliber to work with present organization cause of salary reasons...boo.. hooo...hooo. My email address is alkaa.dugaal@gmail.com

0 Answers  

---

i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet

0 Answers   IBM,

---

---

I have 5 save buttons in my application on 5 different tabs one after the another . I have spy them and added each of them in my OR. My Or is able to highlight each button on each of the 5 tabs. But when I run the script it does not click the object.Is there anything I have to edit in OR. Any property to add or delete? Below are the properties of 5 save buttons. My code for each is like browser().page().savebutton1.click Browser().page.savebutton2.click Properties of 5 buttons Dhopare, Namita Sent: September 2, 2015 2:57 PM To: Vullengala, Jagadeeshchandra "Class Name:=WebButton", "abs_x:=718", "abs_y:=693", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSaveTab1", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSaveTab1"" class=""Button"" onclick=""document.getElementById('a1').click();"" name=""btnSaveTab1"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=718", "y:=616" "Class Name:=WebButton", "abs_x:=687", "abs_y:=571", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSave", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSave"" class=""Button"" onclick=""document.getElementById('a2').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=687", "y:=494" "Class Name:=WebButton", "abs_x:=635", "abs_y:=478", "class:=Button", "disabled:=0", "height:=23", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a3').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=635", "y:=401" "Class Name:=WebButton", "abs_x:=695", "abs_y:=558", "class:=Button", "disabled:=0", "height:=22", "html id:=BtnExternalPartySve", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""BtnExternalPartySve"" class=""Button"" onclick=""document.getElementById('a4').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=695", "y:=481" "Class Name:=WebButton", "abs_x:=672", "abs_y:=642", "class:=Button", "disabled:=0", "height:=22", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a5').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=672", "y:=565" Previous Item Next Item Connected to Microsoft Exchange

1 Answers  

---

what skills needed to be good test automation?

3 Answers  

---

How can i initiate the objects to find uniquely in OR

0 Answers   IBM, Livetek,

---

What is smart identification?

2 Answers   Ordain Solutions,

---

What is BPT?

2 Answers   Allied Group,

---

Explain the check points in quicktest professional?

0 Answers  

---

WHAT IS THE FRAMEWORK & ARCHITECTURE OF YOUR PROJECT

3 Answers   Wipro,

---