Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to connect to data base?

Answers were Sorted based on User's Feedback



How to connect to data base?..

Answer / jayadev acharam

Using ADODB Object
Example
DB_Connect=CreateObject(ADODB.Connection)

Is This Answer Correct ?    4 Yes 0 No

How to connect to data base?..

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

Post New Answer

More QTP Interview Questions

difference Between Call Run action and copy of action?

3 Answers   Quest,


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?

2 Answers  


can anyone proide me reading material on svit00ef27@yahoo.com please thanx in advance

2 Answers  


can u put checpoints for moving images

2 Answers   Accenture,


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..

0 Answers  


Hi Samrat, Thank u very much, what u said it is right.

0 Answers  


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

0 Answers  


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??/

0 Answers  


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<--

4 Answers  


What is qtpro? What is quick test pro?

0 Answers  


list me out the shortcutkeys for some functionlities in the qtp for example to record ,to run ... etc

2 Answers   CTS,


your doing one project testing then how u know itis wheather web based application or windows based application?

2 Answers  


Categories