How to connect to data base?
- 2 Answers
- 4463 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / m.s.patil
You can write OLEDB script:
Set Con =CreateObject("ADODB.Connection")
ConString="Provider:SQLNCLI;Server=plantdev;DataBase=QAServe
r;UID=patil;PWD=password1"
Con.ConnectionString=ConString
Con.Open
| Is This Answer Correct ? | 0 Yes | 1 No |
Which is the best testing institute for QTP training in Hyderabad.
If u r using library files (Instead of Check Points) , How do u do bitmap check ?
iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?
What the differences are and best practical application of Object Repository?
what r the drawbacks and limitations of QTP?
Can any one explain about environment variables with examples?
what is a test strategy & what is the difference between test strategy & test plan?
QTP WAS WORKING FINE BUT TODAY I GOT THE ERROR , THE MEMORY COULD NOT BE READ -REFERENCE MEMORY ,pPLEASE REPLY URGENT WHAT IS THE SOLUTON
How to create Reusable and Multiple Actions?
Hi PLZ explain User Defined Functions in QTP with eample?
Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks
Explain how qtp identifies object?
WinRunner 
