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 the Database from QTP?

Answer Posted / murali raju

Through scripting this is way to connect the database
Example:-

set conn=Createobject("ADODB.Connection")
Srvname="Driver={Microsoft ODBC for
Oracle}:Server=DBserver,UID=Sa,Password=sa"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="select * from Users"
Rec.open SQL ,conn
Username=Rec.fields("employee name")
Msgbox Username

Is This Answer Correct ?    86 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi i am working with vbwindow on qtp.first i am openning qtp whenever open qtp my application not open that time generated error like "Runtime error 0" and fatal error:automation error how to solve this problem pls tell me

2386


What do you mean by iteration?

1208


What environment does qtp run in?

1116


if our qtp vb Script may be Currepted then What we want do?

1914


How can i initiate the objects to find uniquely in OR

1913


Give me some real time point of way where exactly we can conduct audits?

1906


Explain how Selenium is different from UFT?

1269


Is it possible to refer the same object for referring more than one object that are of different class using the descriptive programming approach? Suppose my code is 'To create the object named as obj Set obj=Description.Create() 'To define the values obj("title").value="IE" obj("type").value="text" obj("html tag").value="INPUT" 'To set the value Browser("IE").Page("Yahoo").WebEdit(obj).Set "xyz" Can I refer the "obj" object for the three objects like Browser,page and webedit objects? If so how?

2125


What are table and db checkpoints?

1078


How many tabs are available to view your test in a test pane and what are they?

1075


In what occasion we can specify global sheet and action sheet?

1036


For which type of projects the iterative model is not suitable?

1887


can any one please tell me which is the best institute in Bangalore to learn QA (crash course)? Thanks

2100


How to use parameterization in qtp?

1071


what is the diffrence bw qtp architectute and qtp framework?

2005