In my AUT, For one of the functional flow , I need to delete the data from front end and than need to verify the data in database (by looking in to one of the database table, as there is no way to verify this from front-end)
In current manual process , manual testers are using TOAD to query the required database table and verify data.
With automation, my thought process is to connect to database using VBScript Descriptive programming and retrive the dataset before and after the data deleted and verify. Is this correct approach?
If yes than can any one please share the sample code to connect to database (here its Oracle) using VBScript?
Re: Help: Connect to oracle database from QTP script
You may try:
' Oracle client is required to be installed on your box
conn.open= "Provider=OraOLEDB.Oracle.1;Password=***;Persi st Security Info=True;User ID=****;SERVER=****;Data Source=****;DBQ=****;"