Interested to Buy Any Domain ? << Click Here >> for more details...
write progamming connecting QTP to database sql? this is
question asked by interview? please give sql, pl/sql related
answer?pls any answer this?
- 3 Answers
- 8676 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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)
| Is This Answer Correct ? | 7 Yes | 1 No |
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
| Is This Answer Correct ? | 2 Yes | 0 No |
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
| Is This Answer Correct ? | 2 Yes | 1 No |
How to capture checkbox properties when properties of the object keep changing on relogin to the application.
What is Active Screen in QTP?
in which case & which method we can use "native" property of an object ?
what is the difference between DATA TABLE and DATA SET?
What are the different kinds of test steps?
How to handle dynamic objects in quicktest professional?
what is Action conversion tool? what the Action conversion tool will do?
Synchronozation types in QTP
Why do you choose only QTP for your project automation among remaining tools like Rational robot and silk test?
what is clean sweep?
Hi, Can anyone tell me what type questions can be ashed in interview on QTP?
What is the Major difference between QTP ; LoadRunner? If u want to test an 1. erp module which automation tool you would prefer and why? and 2. for web application, which tool and why?
WinRunner 
