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 qtp to sqlserver?(if any body know about this please send mail to me:sheik_feroz5@yahoo.com)thank u

Answer Posted / sunita

Dim sServer, sConn, oConn, sDatabaseName

sDatabaseName = "Migrations"
sServer = "hyrdwsz0010"

Set oConn = CreateObject("ADODB.Connection")
oConn.Open "provider=sqloledb;data source=" & sServer & ";initial catalog=" & sDatabaseName &";Trusted_Connection=Yes;"
oConn.CommandTimeout = 0

Set oRs = oConn.Execute("Select * from dbo.CLIENTLISTSS")
Set RowCount= oConn.Execute("Select Count(*) from dbo.CLIENTLISTSS")
Msgbox FormatNumber(RowCount(0),0)
Msgbox oRs.Fields.Count
Msgbox oRs.Fields.item(1)
arraydata=oRs.GetRows
Msgbox arraydata(1,1)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to evalute defects in QTP script?

1940


Will down time for server and content maintenance/upgrades be allowed? how much?

1018


How can you close the second opened browser?

1335


how can we preform retesting(DATA driven test) using function please gine the code for loginpage

2808


what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

2138


Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?

979


explain abt dyanamic changing object with example?

2281


How to suppress warnings from the test results page?

965


Key word driven framework

2125


How can you write the scripts that operate on different objects depending on run-time information?

2521


banking domain description for software tester for interview

3858


what is the structure for the data driven framework

1950


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

2048


Why is action split used by qtp?

926


What is checkpoints for qtp?

913