Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 9522 Views
- I also Faced
- E-Mail Answers
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 |
How to write test cases for web applications using QTP.plz write a sample test case to show how to write.urgently needed.thanks in advance..
On what basis we select test cases to automate?
What are the points to be taken into consideration while doing desktop testing?
I am not finding pages and links in object spy on web testing. I am only getting window and winobject. where is the problem? thanks
How to open a new test using QTP?
WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT
anyone can explain about "Hybrid framework" in QTP
What is qtpro? What is quick test pro? What is a quick test professional?
If an application name is changes frequently i.e while recording it has name "Window1" and then while running its "Windows2" in this case how does QTP handles?
What is Distributed testing? How does UFT support it?
can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
WinRunner 
