Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ravi
QTP supports interaction with Database using ADODB.
Set con = createobject("ADODB.Connection")
Set rs = createobject("ADODB.Recordset")
'Create DSN(DataSourceName) for your database and specify
the DSN here
'You can also establish connection using Provider name
con.open "DSN=MyDsn;UID=ravi;PWD=sample123"
con.execute "Insert into emp values(2500, 'Ravi')"
'Retrieve data from database
rs.open "select * from emp", con
while not rs.eof
msgbox "ID = " & rs(0) & " Name = " & rs(1)
rs.movenext
wend
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi All, How to get repeated word in string . Thanks Balaji
How many ways we can parameterize data in quicktest professional?
give me the code to save all messages of inbox of gmail into a folder and notepad
how to test use the quality control .how to verify the image verification
What is Associate Repository in QTP 9.2 ?
Where you are storing your script?
How does qtp identify gui object?
What are the features of quick test pro(qtp)?
What is the keyword view and expert view in qtp?
What is the use of an object spy tool in qtp?
can i compare two databases using QTP ?
What are the challenges u faced in testing with crm domain? How u overcome with?
What are the Disadvantages of shared object repository?
In QTP can we feed the out of one browser(internet explorer) as an input to the another browser(mozilla firefox)? If yes explain how to do it with an example.
What is throw Object?
