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 |
what is On Error Resume Next ?
write qtp descriptive programming to activate multiple notepads? please urgent friends
what is automation(qtp)bug pls giv me one ex?
Have you used TD?
We have a dynamic webtable where rows keep on adding.I have to click on particular row where the status changes to Update or Save.How do you click on Status(either it can be Update or save)
what is the long form of QTP ?
I have java based application on my computer. Can I install QTP on it? What are system requirements for installing QTP?
why text area checkpoints cannot used for web applications
I want to do QTP Certification what is the pattern of Question paper.
Could you please explain me about QTP framework.
How did you use regular expressions in QTP and also in WR?
Is there is any method how to connect remote desk throw QTP if yes please answer with a example?