How to connect to data base?
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 create runtime property for an object?
Explain the views in the QTP GUI?
Hi All, I have QTP installed on my machine but the application under test is on remote machine. I need to automate the scenarios which consist of automatically enter the remote machine through IP address ,record the application in remote machine and run it also when played. Can some one tell how to record the application in remote machine.
Tell about automation object model(Aom) in qtp?
Suppose if a functionalityis not mensioned in requirement document and but its present in application. will it be consider as a bug and viceversa?
Approach for Installation,comaptibility,system testing
What phases are involved in testing an application in qtp?
any one can explain about QTP proocess,means where to start and how to start Scripting.
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
I want to open a text file and then search some specified text in it and then replace that text with some other text i found that text in .txt but do not know how to replace that text can any body help me. if possible put the code for qtp
Is there any vbscript in QTP for Data Driven Test instead of using the option provided by QTP?
How to Import the data from MS-Access in QTP?