I am new to QTP and we are doing Data base Comparison Testing using QTP. Please let me know on how Estabilish DB connection using QTP for Oracle ODBC.
Search this forum.
You need to know connection string to make connection to database. Find it at http://www.connectionstrings.com/ and use these connection string to connect to the database on your system or on lan....
This article explains all http://qtp.blogspot.com/2008/08/qtp-script-11.html
In general QTP can use database resources already installed on most computers. The most common are ODBC and ADO and both can be used to communicate with an Oracle database using VBScript code in QTP. For examples check out
Database Comparison!! How many records that you wish to compare!! Is it a complex query!!!
As suggested above, you can use ADODB with either DNS or Connection string for setting up DB connection
Winds of Change