Manage Test Sources

A test source is an ODBC data source and, optionally, all the information necessary to connect silently to that data source. Usually, auto tests are run as a background task — either overnight or on a separate machine — so they should be able to connect to a data source without prompting you for connection information. The ODBC Test Handles test source, which uses the connection and statement handles from the current connection, is always available.

To create a test source

1. In ODBC Test, from the Tools menu, choose Manage Test Sources. ODBC Test displays the Manage Test Sources dialog box.
   
   
2. Click New and type the name of your test source in the Test Source box, then click OK.
   
   
3. Select the data source you want to access from the DSN list. If there are no data sources in the list, you can create them with the ODBC Administrator. For more information, see "Managing Data Sources" under "Microsoft ODBC Data Source Administrator."
   
   
4. If your data source requires a user and password, type the user ID in the UID box and the password in the PWD box.

   Caution   The password is stored in unencrypted form either in the gator32.ini file for the ANSI version, or in the gator32w.ini file for the Unicode version. Because of this, you may want to create special data sources and passwords for use with ODBC Test or use only the ODBC Test Handles test source.

5. If your auto tests require any other keywords or attribute values, type these as strings in the Keywords box. Your test will be passed the keywords by ODBC Test. For example, to specify the Employee database and the DBNMP3.DLL network library, you might type these keywords:

   DATABASE=Employee;NetLib=DBNMP3
   

6. Click Close.

You can also modify or delete test sources with the Manage Test Sources dialog box.