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
how to evalute defects in QTP script?
Will down time for server and content maintenance/upgrades be allowed? how much?
How can you close the second opened browser?
how can we preform retesting(DATA driven test) using function please gine the code for loginpage
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?
explain abt dyanamic changing object with example?
How to suppress warnings from the test results page?
Key word driven framework
How can you write the scripts that operate on different objects depending on run-time information?
banking domain description for software tester for interview
what is the structure for the data driven framework
can any one please tell me which is the best institute in Bangalore to learn QA (crash course)? Thanks
Why is action split used by qtp?
What is checkpoints for qtp?