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 |
difference Between Call Run action and copy of action?
hi i need to learn qtp its very urgent..pls tell me who is the best faculty for qtp in hyd..... and i plan to go foe mindq nageshwar rao? its good or not?
can anyone proide me reading material on svit00ef27@yahoo.com please thanx in advance
can u put checpoints for moving images
Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..
Hi Samrat, Thank u very much, what u said it is right.
Hi All, I need 5 yrs exp manual and automation testing using QTP sample resume. is there any body having please send me my mail id is bjr@aol.in Tahnks in Advance
Hi, I got some difficulties in automating a web check box in a peoplesoft application. Let me explain the scenario, When clicked on a look up button in the application, it navigates to a new page with check boxes and respective options. Below is the source code for one check box and its option. <input type='checkbox' name='H1AU_BUNDLE_WRK_H1AU_SELECT_CH$2' id='H1AU_BUNDLE_WRK_H1AU_SELECT_CH$2' tabindex='34' value="Y" onclick="this.form.H1AU_BUNDLE_WRK_H1AU_SELECT_CH$chk$2.valu e=(this.checked?'Y':'N');submitAction_win0 (this.form,this.name);" /> </td> <td align='left' class='PSLEVEL1GRIDODDROW' > <span class='PSEDITBOX_DISPONLY' >$29 - $29 Cap with FREE Mobile</span> I want to parametrize using "$29 - $29 Cap with FREE Mobile". I am not aware of how to parametrize this. Currently I am parametrizing with 'H1AU_BUNDLE_WRK_H1AU_SELECT_CH$2' Can any one please help me out with this??/
Hi..friends can anybody write the script for this question... Am having some 20 nos of links in a web application, i want to click some 5,13 & 17th links. So please....can anybody give the answer....??? -->Hani<--
What is qtpro? What is quick test pro?
list me out the shortcutkeys for some functionlities in the qtp for example to record ,to run ... etc
your doing one project testing then how u know itis wheather web based application or windows based application?