ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
What are the details steps to connect a remote mysql 
database in QTP
 Question Submitted By :: Vineela
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the details steps to connect a remote mysql database in QTP
Answer
# 1
This is code to run sql query through qtp.

SQL "SELECT * FROM ORDERS" 
connection_string "QT_Flight32" 
columns 1 
set connection CreateObject("ADODB.Connection") 
connection.Open connection_string 
set rs1 connection.Execute( SQL ) 
rows db_get_rows_count(rs1) 
msgbox rows
rows rows-1
myval db_get_field_value(rs1 rows columns ) 
msgbox myval
 
Is This Answer Correct ?    0 Yes 3 No
Santhosh Ankam
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
How to call a function in QTP?Is there any method ? Thanks , PRASANNA  2
What are the advantages of QTP over WinRunner? CTS4
Are You using any frame work? What is that? Explain about that. Wipro4
How 2check the color of the text in the textfield . say suppose the text entered in the textfield object is appearing in red. so i want to check whether the text is in red color or not. It could be great help for me if any one solve's my issue. plz...help Sinertel5
How does QTP identifies the object in the application Convergys5
what is diffrense between action and function IBM3
Hi all im having a pop up validation browser which is 20 in number, i want to close those similar pop browsers one after the other, is there any specific code for that? i tried by giving creation time & putting in a loop but it dint work? valid working answers will be greatly appreciated McAfee2
How to export data present in Datatable to an ".xls" file?  1
What is BPT?  2
how to invoke the web application through script in qtp Synechron5
take one example and write vbscript on one web application in qtp? explian descriptive programe with one example? IBM2
How can we disable popup blocker? (I think it means when we get a pop up messge(its error) how we wil disable that one with out interrupting normal process)  5
How will u declare a variable to access multiple actions? a)Dim b)Global c)Public d)Private  1
does qtp runs on internet explorer 7.0 BeBo-Technologies5
Hello, I am learning QTP. I have recorded test for Login page, i have also inserted checkpoint for Email field & when I run test it passed. But when i tried to run test by inserting 'Adding Parameter Values to a Data Table' for email & password field, it pass the first value in both the fields but after that when test run for second parameter values it displays 'Internet Explorer cannot open the Internet site, Operation aborted' & when i analyze test result it displays run time error 'Object disable'. I have also cleared all the history from IE but it is not working. Please help me. Thank you.  2
what are the mandatory properties in qtp? what are the library functions in qtp? Wipro3
how to parameterise a test with data base table or excel sheet? FCG1
Hello Everybody, Can anyone tell me that in QTP how to count the number of webelements from the object repository. Please provide the code. Thanks in advance, Gaytri  2
WHAT IS THE USE OF "FUNCTION GENERATOR" IN QTP? CTS7
how are environment variables used in real time projects (testing)?what answer should be given about this in interview.need real time explanation breifly?thnx in advance.  2
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com