This page is designed to specify data storage.

See the image below:

AVElife TestGold Studio d options 16 400 Data Store Page

Initially, all the application data are stored in special local file storage, but TestGold permits you to choose the most preferable place for storing your data. To change it, select appropriate Storage option.

Select Local File Storage option to store the application data in the file storage. It is recommended for storing of practically invariable medium-volume data (approximately to 500 users and 10000 test sessions).

Select Local Default Database option to store the application data in local MS Access® database, created by default.

Select MS Access Database (MDB) on Server option to store the application data in specified MS Access® database, placed on network server.

Select MS SQL Server Database option to store the application data in specified Microsoftâ SQL Server database.

To connect to the database, TestGold uses modern technology ADO (ActiveX Data Objects).

Now specify connection properties in appropriate fields and press Verify button to check storage definition.

Storage Definition

Local File Storage
No properties.

Local Default Database
Single property – OLE DB Provider. Don’t edit if you already have good connection.

MS Access Database (MDB) on Server
You need to specify shared server folder and database. Type full network folder name in Server Shared Folder field or press Choose button to launch Choose Folder dialog. Then, if file TestGold3.mdb will not be found in specified folder, you will be requested to allow to copy database file to the folder automatically. Usually it is enouth. If you have any problems, check settings of shared folder (change rights required) and firewall settings to prevent lock of server data for the software.
If you want to use the database with other file name, just copy it to the folder and specify database file name in Server Database field manually.

MS SQL Server Database
First, create SQL Server database. Just open the database TestGold3.mdb in Microsoft® Access® and convert it to SQL Server format. Then specify connection properties Server Instance, Database, User ID and Password manually or build database connection in dialog (mark Use Connection Dialog option and press Build button). If you use SQL Server version different from Microsoftâ SQL Server 2005, probably, you need to correct default OLE DB Provider value.

Data Store Page