How do u connect database through QTP
tell me both Ms Access and SQL
Answers were Sorted based on User's Feedback
Answer / prasanth
we can connect to database in QTP using "ADODB" connection
object.
Sample code for SQL Server:
set mycon = createobject("ADODB.Connection")
mycon.open("driver=SQLserver;server=localhost;database=
(database name);trusted_connection=yes")
set myresult=mycon.execute("select * from sample")
while myresult.EOF <> TRUE
msgbox.myresult.fields(0)
myresult.movenext
Wend
you can get the connection strings
for "connectionstrings.com"
Kumar.rnv@gmail.com
Broadridge
| Is This Answer Correct ? | 8 Yes | 1 No |
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What is the difference between them? How to handle script issues?
why we use environment variables
Can anyone pls tell me how to do action parameterization (input and output parameters) with respect to login window and insert order of flight reservation window in detail( pls give a clear step by step explanation with example) anyone please. Will be very thankful to u
i don't have any experience in qtp? Can u please tell me What work i have to do?
Please Clarify if smartidentfication is used at runtime when qtp does not recogonize the objects
Explain the types of object repositorys in qtp?
Hi,can anyone tell me How to found the number of 1's and 2's in the given format 1,1,2,2,3,3,4,2 using vbscript Thanks in advance
How can we do this one ? at runtime qtpwindow and browser aren't disply on monitor (or) aren't visible on desktop?how?
Hi, My application is a web application which was developed by Java. In that application we have applets to do some operations. Is it possible to recognize applets using QTP? If yes, how? pls, help me this
can anyone tell me from where i can download qtp demo or crack version
Please explain about unicode compatibility in QTP. how we can able to use it. Please help me
how to test background color and dynamic images during runtime