How to connect to the Database from QTP?
Answer Posted / murali raju
Through scripting this is way to connect the database
Example:-
set conn=Createobject("ADODB.Connection")
Srvname="Driver={Microsoft ODBC for
Oracle}:Server=DBserver,UID=Sa,Password=sa"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="select * from Users"
Rec.open SQL ,conn
Username=Rec.fields("employee name")
Msgbox Username
| Is This Answer Correct ? | 86 Yes | 20 No |
Post New Answer View All Answers
Explain quicktest professional (qtp) testing process?
Why is action split used by qtp?
Can U Explain about QTP tool from older version to latest version also its differences?
In qtp is it possible to check broken links of a page?
How qtp identifies objects?
Mention what are the different types of recording modes in qtp? Which will be used when?
can u explain the keyword driven framework with an example clearly how to create all the files and how to attach to main test.
how u will evaluate the tool for test automation?
How to get the particular property value?
What are the types of environment variables in qtp?
What is different command used in command Prompt while using QTP?
What are the types of properties that quick test learns while recording?
I had installed QTP 9.2. It is working fine but whenever I open QTP, it is trying to reinstall the below-mentioned files again and again "QTP92PS82UPGRADE.exe", "recogn.dll". If anybody has these files, please provide those files in this site or you can send that files to my mail id also (lravi4u@yahoo.com). If you don't know where the files will be in the QTP, search in the QTP software CD or path of QTP program installed (C:\Program Files\Mercury Interactive\QuickTest Professional)
What are the advantages of qtp?
Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...