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 open a new test using QTP?
How to add Dynamic Objects to Object repository?
how to capture (or) checkpoint for chineese or any other language except english using QTP in a web page. ( my application have 24 language, how to check those lanugages using QTP? is it possible). Please let me know
What is the vb script when the url enter into the browser
How do you invoke any application and write a script to invoke QTP using VB Script.
What are the enhancements u did after recording ur script?
In descriptive programming how we know the properties of the objects, if application is not developed and the prototype of the application is also not developed.
Explain about random testing of 500 test cases?
What is the extension of qtp local repository?
What is the difference between Call to Action and Copy Action.?
Hi, While recording a Jave based web application, its recording all my actions and the objects.And I have 5 WebEdit objects on the page and all are recorded. But while execution, at the 2 WebEdit object, its entering the value into the object (Its making a call to the AJAX, matching the value), when the control get out of this object the value is erased or cleared. Could anyone please help. I have recoreded 5 more scenarios where WebEdit is in the picture on different webpages and all are working fine. Here is my Script: Browser("Sign In").Page("Matching Workbench_3").WebEdit ("locationLookup").Set "0320 - SEATTLE-KM" Browser("Sign In").Page("Matching Workbench_3").WebEdit ("supplierNameLookup").Set "TRAMMO PETROLEUM INC" *** SupplierNameLookup is the object, which is haing an issue. And also I was using the SendString function, but it didnt work.
What is the limitation to XML Checkpoints?