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
- 7157 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 |
does qtp need record and playback in realtime. plz tell exactly wat happens
I have written some script in QTP and i added those objects in Object Repository. All written script has been executed successfully. After few days when i tried to execute the same script i got error message "objects not found in Object Repositiry". How can we solve this issue?
An object is created, i dont know the methods available for that object, i want to find methods available for that object and use the required method. How i can do this???
What is vulnerability?
What is accessibility check point?
What is output value? How many types of output values are there in qtp?
write script for , launching fr window,login and create 5 elements array and store 5 order numbers inthat array? and open order by using order no.s in array and find out maximum tickets booked by which order?
what is vmodel?advantages and disadvantages of vmodel?
what is Function Definition Generator? can any one explain me in details?
anyone can explain about "Hybrid framework" in QTP
Test script is generated and it is enhanced.It is required to be saved.But the disk space is insufficient.You are not permitted to delete any scripts.How are you going to save?
what are the qtp tester responsibilities?
WinRunner 
