To establish database connection, first we have to build DSN( Data Source Name) .The DSN may be User DSN or System DSN as per your requirement.
Check the difference between User DSN and System DSN . In my example I used System DSN.
Steps to create System DSN:
- Start->Setting->Control Panel
- Click on Administrative Tools
- Click On Data Sources(ODBC)
- Click On System DSN->Add
- Highlight Oracle driver
- Click on Finish
- Enter value for text box as follows
Data Source Name — anything you like ( It should be meaningfull name,this will user by QTP to connect to database)
Description(optional)
TNSÂ Service Name — Oracle database name ( SID)
User ID – User id for the schema you want to connect ( Scott)
Click Test Connection – Provide password for User ID(tiger by default, may be different in your case)
After test , Connection Successful message should get, otherwise some issue resolve it.
Note my system DSN name is : oracle10g
ODBC driver name is : Oracle in OraDb10g_home1
On QTP make a connection string as per the following examples
oracle and QTP connection
Posted in Automation Solutions.
Tagged with Data Source Name, Database (Oracle) Connection with QTP, System DSN, User DSN.
By paresh
– May 8, 2010
System DSN
System DSNs work for anyone using that system. For example, no matter who logs onto the machine, system DSNs can be seen by all users, and they are stored in the Local Machine section of the Registry.
User DSN
User DSNs work only for a specific user on a machine. Therefore, if someone other than the person who created the user DSN logs onto that machine, then the User DSN will not show up. This DSN is stored in the Current User section of the Registry.
Posted in Uncategorized.
Tagged with Difference between System DSN and User SDN, System DSN, User DSN.
By paresh
– May 8, 2010
Following factors effects on test automation :
1   Automation Framework   Availability   High
A Good framework makes your scripting, debugging and maintenance easier. Do understand that framework needs continuous updating across the script development.
Continued…
Posted in Automation Framework.
Tagged with Automation Framework, Factors that affects test automation, Test Automation.
By Atul Sinha
– February 15, 2010
Now a days web application testing is becoming increasingly important as customer seek to deploy application faster at lower cost and with high quality of service. Quality assurance(QA) professionals want web application testing solution that prevent costly application performance, avoid unplanned outages of business critical applications, and automate the manual steps involved in application testing.
Continued…
Posted in Automation Solutions, Functional Automation Testing.
Tagged with Oracle Application Testing Suite, Testing Web applications, web application testing.
By Paresh
– December 5, 2009
Microsoft Research Event : TechVista 2010, Microsoft Research India’s flagship event will be held on Friday, January 22nd 2010 at Bangalore, India. Bringing together computer scientists and thought leaders from academia, government, and research institutes.
TechVista 2010: PhD Poster Session
Continued…
Posted in Events.
Tagged with Microsoft Research Event, Microsoft Research India, research symposium, techvista 2010.
By Atul Sinha
– December 3, 2009
HP Quality Center, Web-based test management tool, simplifies and organizes test management by giving you systematic control over the testing process.
To fulfill a specified testing requirement of your application.
To meet the various goals of a project.
Help in Application testing of complex processes
Help create a framework and foundation for your testing workflow.
Quality Center provides an intuitive and efficient method for scheduling and executing test sets, collecting test results, and analyzing the data. Different Quality Center Add-ins are available are as follows: Continued…
Posted in Quality Center.
Tagged with HP Screen Recorder Add-in, QTP Business Process Testing, Quality Center Add-ins, Quality Center Explorer Add-in, Quality Center Synchronizer, QuickTest Professional Add-in, Service Test Add-in, SOX IT Assessment Accelerator.
By Atul Sinha
– November 29, 2009
Now automation has begun to impact this every areas of Information technology .in this article I just want give some information about automation trends on database administration. Automation of database activities causing the reduction of database related tasks. DBA have to do lots of repeatable tasks every day to maintain database. Some DBA need to perform at off-hours.
Continued…
Posted in Automation Trends.
Tagged with Automation impact on database administration, Automation of database activities, database administration, database automation software.
By Paresh
– November 21, 2009
The Quality Center Open Test Architecture API is a COM library that enables you to integrate external applications with Quality Center.
Quality Center OTA Object Hierarchy
Object Hierarchy of Quality Center OTA Objects , show the type of relationship between the elements. The type of relationship between the elements may be different from object to object. For the details of how to get a reference to an object, see the help page for the specific source object.
Quality Center OTA API Object Model
There are many ways to use Open Test Architecture programming Continued…
Posted in Quality Center.
Tagged with Open Test Architecture API, Quality Center, Quality Center OTA API.
By Atul Sinha
– November 17, 2009
TestLink 1.8.4 popular and acclaimed free, open source Test management tool. TestLink create and manage Test cases as well as organize them into Test plans. TestLink makes Testing process easy and organized. These Test plans allow team members to execute Test cases and track test results dynamically, generate reports, trace software requirements, prioritize and assign tasks.
TestLink - Test Management Tool
TestLink fully free Test Management tool Continued…
Posted in Open Souce.
Tagged with execute Test cases, manage testing process, Test management tool, TestLink, trace software requirements, track test results.
By Atul Sinha
– October 28, 2009
The Google Wave API allows developers to use and enhance Google Wave through two primary types of development:
- Extensions: Build robot extensions to automate common tasks or build gadget extensions to provide a new way for users to interact
- Embed: Make your site more collaborative by dropping in a Wave
Google Wave API
Google Wave is currently available in a developer preview as the APIs and product continue to evolve. Accounts on the developer sandbox will be given out to Continued…
Posted in Automation Trends.
Tagged with Automate common tasks, Google Wave, Google Wave API, Google Wave Federation Protocol.
By Atul Sinha
– October 23, 2009
