how to connect qtp to sqlserver?(if any body know about this please send mail to me:sheik_feroz5@yahoo.com)thank u
- 3 Answers
- 5949 Views
- Honeywell, I also Faced
- E-Mail Answers
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
For which type of project the iterative model is suitable?
what r the verstions from 1st to present (verstions) of mercury tools (like winrunner,QTP,Loadrunner) ? Chandana
Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?
whenever U using QTP,Test Director, Why we using separate Bug tracking tool?
Hi can anybody send me the QTP material, To my email ID: nuve1284@gmail.com ?
To which environments does quicktest professional supports?
I want two test two agents login for the flight website. Here is the scenario: I want to go through 1-3 rows for one user login and other user login I want to go though 3-5 rows. How would you set this up in qtp. Thank You
What are the advantages of qtp?
1--How many functions u develop 2--What is an array 3-- where is ur server 4--U involved in unit testing 5--how ur test the background colour using QTP
What is difference in global and action sheet in qtp?
why text area checkpoints cannot used for web applications
Qtp has been installed on my pc but recently ON opening it is giving this error PLEASE REPLY IT IS URGENT IT WAS WORKKING FINE QTPRO.EX THE instruction at "0x7.. ...". referenced memory at "0000....The memory could not be read... Awaiting QTP XPERTS REPly URGENT
before launching qtp, we need to close all the open browsers u dont know what are all the browsers either it might be ie,mozilla etc and u dont know how many brosers are open.... u need to close all these before launching qtp.. can anyone plz temme d solution...
i have asked earlier only one question how to test web application using QTp plz send me the answer quickly
Explain the new feature of UFT regarding the export of test results?
