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 the extension of the recovery scenario file in qtp?
What are main panes available in qtp test browser?
How to test fly out menu in qtp?
how to test a java project throughqtp?while testing a vb project we generally do vb scripting. but while testing java project do we use java script .plz some one can send me the manual for it my email roy_samata@yahoo.com thanks in advance
Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project
How many types of parameters are available in quicktest professional (qtp)?
How to check the URL using Automation tool QTP
Hi all, what is the latest version of QTP?
Dear Friends, I having total 3+year experience in manual testing including automation testing QTP, if i am attending any interview what kind of question will i get? please help me out
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)
Is it mandatory to know abt regular expression in descriptive programming
what are the difference ways of parameterising?