I would like to ask is TestComplete supports database testing? I know that Microsoft's ADO and Borland's BDE engines can be used for access to databases.
Is this fully compatible with SQL Servers? Can I call stored procedures and provide required inputs? What other types of databases can be tested? (such as Oracle, or others).
Could you please let me know if you have used TestComplete for database testing and for what types of tests?
You can work from TestComplete with all databases that can be accessed using ADO and BDE. Please see the samples shipped with the tool and let me know if you have any questions. You can find links to these samples in the 'Retrieving Values From Database Fields' help topic.
As for the stored procedures - you are able to call them from TestComplete. If you use the BDE object to connect to the database, you can make use of the 'CreateStoredProc' method of this object (see the 'BDE.CreateStoredProc' help topic for details). In case you work with the ADO object, you can use its 'CreateADOStoredProc' method (see the 'ADO.CreateADOStoredProc'). Please note that unfortunately there is an issue in the ADO plug-in - the 'Parameters' property of the 'IAQAADOStoredProc' object that is returned by the 'CreateADOStoredProc' method is not accessible. So, currently you can call only the procedures without parameters. The fix to this problem will be included to the next update of TestComplete. But if you need the fix now, you can contact our Support team (firstname.lastname@example.org) and they will send it to you.
The below script demonstrates how the 'CustOrderHist' stored procedure of the 'Northwind' database can be called from TestComplete using the fixed ADO plug-in.