Interested to Buy Any Domain ? << Click Here >> for more details...
How to connect to data base?
- 2 Answers
- 7044 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jayadev acharam
Using ADODB Object
Example
DB_Connect=CreateObject(ADODB.Connection)
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / akshay
Public Function database(Str,SQLstr,outResult1,outResult2)
'//Variable Declarations
Dim objConn, rsOut
'//Create a connection object.
Set objConn = CreateObject("ADODB.Connection")
'//Create a ResultSet Object to store the results.
Set rsOut = CreateObject("ADODB.Recordset")
'//Open the Created Connection object
objConn.Open Str
'//Pass the SQL query string and retrieve the Results
through the connection object
rsOut.Open SQLstr,objConn
If rsOut.EOF <> True AND rsOut.BOF <> True Then
'//Store the different column values
retrieved from a record in different variables.
outResult1=rsOut("col1")
outResult2=rsOut("col2")
rsOut.movenext
End If
End Function
| Is This Answer Correct ? | 4 Yes | 0 No |
How to import a test case present in ".xls" file to TD under a Test set?
In how may ways we can use checkpoints to an application using QTP?
The string is like POWER STAR PAVAN , write a script for this how to findout the number of "A" in the string ?
How to send QTP scripts to our colleagues?
What are different types of frame works ?
how can i pass a "cript"as a parameter in to a function
how can i count the number of links???
1.IF SOME OBJECT IN APPLICATION IS NOT IDENTIFIED BY QTP? HOW WILL YOU OVERCOME THIS? 2. WHEN AND WHYDO U GO FOR DESCRIPTIVE PROGRAMMING? 3. WHAT IS THE DIFFERENCE BETWEEN VB AND VBA? 4.WHAT ARE THE REGULAR EXPRESSIONS YOU USED? 5.IF ANY REQUIREMENT IS ADDED IN YOUR PROJECT, HOW WILL YOU PROCEED TO DERIVE THE TEST CASES AND HOW WILL YOU PERFORM AUTOMATION FOR IT?
how qtp identifies objects of application.
What are the ways you can synchronize?
Explain about opening notepad in QTP and writing of test result in notepad?
What is repository parameters in QTP?how will we define that????what is unmapped & mapped repository parameters????????
WinRunner 
