how we connect oracle or sql data server database to qtp.
Hi Ram I was your answer for this. Can you kindly let me
know in details steps on How we can connect to database. i
am using QTP9.2 and SQL Server Database. I am new for QTP
and this would be of great help.Thanks
Answers were Sorted based on User's Feedback
Answer / snig
http://funandknowledge.blogspot.com/2008/03/qt.html
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gms
'Declaration for SQL
Dim objConnection,objRecordset,count1
'Connecting to the database
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open "Driver={SQL Server};" & "Server=YOUR
SQL SERVER NAME;" & "Database= DB NAME;" & "UID=USERID;"
& "PWD=DB PASSWORD;"
'Running the query
sql1 = "GIVE UR QUERY HERE"
'Create record set for the query
Set objRecordset = CreateObject("ADODB.Recordset")
objRecordset.Open sql1, objConnection
As this is a Back-End process, you cannot view the result
set. so you can place the result in the datatable using the
following steps:
'Retrieving data from the database to the data table
count1 =1
While Not objRecordset.EOF
datatable.SetcurrentRow (count1)
Datatable("C",1)= objRecordset("nbr").value
objRecordset.movenext
count1 = count1+1
wend
Is This Answer Correct ? | 0 Yes | 3 No |
i need to learn the descriptive programming very well so for that what to do am reading the qtp user mannual but it is not so any materials or links with examples i want please help me
How do you compare the structure of 2 tables in database and check whether they are similar using qtp.
What is action required by QTP if a popup message is coming in exsisting script and now it is not coming. The script is having code to deal with popup message now when we run the script now the popup i snot coming according to new build, instead of changing the code what we can do?
Please explain about unicode compatibility in QTP. how we can able to use it. Please help me
wht is Automation testing frame work. pls explain it
QTP Data Table Having 10 records with 10 to 15 fields(lets say).now i want to get alternative records from datatable.pls can any one answer it?
How can you pass value one action to another action?
can u please explain what is the exact difference between qtp8.2 and 9.0
There are two tabs in the application suppose, A and B.On clicking the tab "A" one table grid will open. if u click on tab "B" Another table gride will open. Now can I do some operations on both table grids with a single table grid properties in the object repository? I have added all objects of the first table grid into the object repository Now iam checking enable/disable status of "save button" in the second table grid my code is like this val=javawindow("zseries").javabutton("save").getroproperty ("enabled") when I highlighting the save button in the object repository by keeping open the second tablegrid on the application.It is displaying the popup message"The selected object can not be found in the application" can I use properties of one table grid for both tabs if so how it is possible. Can anyone help me
Without QTP (or any Testing tool) can we able to test the GUI part of the Applications. for Example generating the Scripts in Notepad and Executing them Using VB. Is it Possible to do so..
if our qtp vb Script may be Currepted then What we want do?
dar Sir I am Facing th eProblem in QTP thet ,when I start thrcording inthe QTP for the ASP front end and C# the Coding Language I fing that recording is Done well for the Login screen but at the Time Running the script the QTP is Unable to Identify the Objects On the Objec Onht eLigin screen .Please answer the Question in Description and the Propables reason I might be facing alsp the Popable solution I have to Take thanks and ragards