how we connect oracle or sql data server database to qtp.
Answer Posted / mohit
You may try:
Dim rs,sq,pkey
set conn=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
' Oracle client is required to be installed on your box
conn.open= "Provider=OraOLEDB.Oracle.1;Password=***;Persist
Security Info=True;User ID=****;SERVER=****;Data
Source=****;DBQ=****;"
sql="your sql"
rs.open sql,conn
rs.close
set rs=nothing
conn.close
set conn=nothing
Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
i need qtp tutorial. pls send it to sridhar.k151@g mail.com
how to write xml output check point bu useing descriptive programing .means without useing output check point
Can you list some technologies that support qtp?
could any help me please, how to work on visual foxpro application using UFT
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
There is an built in window application in qtp9.1,i.e.Flight4.0.i want to implement the recovery maneger on it.How can i do this?
what type of run time errors you get while you ar edoing rpg program?
What are metrics and matrix?
With what extension you can save the list of tests in a file to run in test batch runner?
What is difference between design time and run time data table?
What are the ordinal identifiers in web page?
What is action?
when I was doing the web testing with QTP using with standard checkpoint the Object selection -checkpoint properties dialog box not displaying pages and links hierarchical order. Could you please tell me. thanks
Analyzing the checpoint results?
In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?