Connecting to database
I need to test the database to verify whether the added, edited and deleted records are updated correctly. Manually I used to check this by executing simple queries in the "Query Analyser" or "Enterprise Manager".
I want to execute the query through "Testcomplete". I have gone through the topic "Working with databases", but I couldnot understand the concept clearly. [img]images/icons/frown.gif[/img]
Can anyone explain me the procedure in steps , how to connect the database, connection string etc in VB Script
Thanks a lot in advance,
Re: Connecting to database
To work with Databases from TestComplete scripts you can use the ADO plug-in. You can find a detailed description of the ADO technology in the MSDN library:
The general procedure is the following:
Create an ADO connection object, specify the connection string ,open the connection, create and execute an ADO command, work with results. I recommend you check sample scripts that you can find in the 'Working With Databases' section of TestComplete help system. There is also a project shipped with the tool, you can find it in the '<TestComplete 4>\Samples\Scripts\ADO\' folder.
Save on AutomatedQA Products