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
- 3 Answers
- 7146 Views
- Honeywell, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajib
set conn=Createobject("ADODB.Connection")
Srvname="Driver=<>,Server=<>,UID=<>,Password=<>"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="<SQL statement>"
Rec.open SQL ,conn
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / mahaboob
set conobj=createobject("ADODB.connection")
conobj.open.provider"providername",Datasource="path of file",uid="username",pwd="password"
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
How to verify the Cursor focus of a certain field?
if anyone has idea of the interview procedure in covansys, plz send me a mail?
Is it possible to change the extension of Shared object repository?
How to Import the data from MS-Access in QTP?
actually how many hours per one day we will work on automation(qtp) in real time
how do u manipulating INI, DLL and / or registry files in support of your test environment? actually what do u mean by INI and DLL or registry files. plzzz its urgent do answer
what is the difference between development and testing
How to Import data from a ".xls" file to Data table during Runtime.
Tell me the QTP Advantages and Disadvatages ?
How do we count the no of mails in Yahoo Inbox for a specified week?
what is advantage of descripting programming in QTP?
How can I use the value retrieved by OUTPUT VALUE check point as Input for other Actions?
WinRunner 
