Setting High-Level ODBC Options

  1. In Silk Performer, expand the Profiles node in the Project tree.
  2. Right-click the profile that you want to configure and choose Edit Profile.
    Tip: Alternatively, you can choose Settings > Active Profile from the menu bar.

    The Profile - [<profile name>] dialog box opens, and the Replay category is displayed in the shortcut list on the left.

  3. In the shortcut list, click the Database icon.
  4. Click the ODBC High-Level tab.
  5. Use the Database area to specify details about the ODBC data source you will use and how Silk Performer should interact with the ODBC driver.
  6. From the Data Source Name list box of available ODBC data sources, select the data source that you want to connect to for testing.
    Note: To set up an additional ODBC data source, use Windows 32-bit ODBC Administrator (via the Windows Control Panel).

    The data source you select here is used only if you use high-level ODBC functions that perform an implicit connection to the database. When you use medium-level ODBC functions, this data source is not used. Instead, the connection is performed with an explicit DB_Connect("connection string") function in the script.

  7. In the UserID text box, enter the user name that is to be used to connect to the data source. You must specify a valid user for the DBMS to which you want to connect. If you use a trusted connection to connect to your DBMS, leave this field blank. Note that the user ID you enter here will only be used if you use high-level ODBC functions.
  8. In the Password text box, enter the password that is to be used when connecting to the data source. You must specify a valid password for the database user you are connecting. If you use a trusted connection, or if the user has no password, leave this field blank. Note that the password you enter here, as well as all remaining options you choose in this area, are used only if you use high-level ODBC functions.
  9. From the Isolation list box, select the level of isolation for the entire test. For a detailed description of isolation levels, consult your DBMS documentation and see the ODBC functions reference. You can change the isolation level and any other DBMS specific settings using the ODBC functions SQLSetConnectOption and SQLSetStmtOption in your script.
  10. From the SQL concurrency list box, select a type of cursor concurrency to use for the scrollable cursors in your test script. For a detailed description of concurrency settings, consult your DBMS documentation.
  11. From the SQL cursor type list box, select a cursor type for the scrollable cursors in your test script. For a detailed description of cursor type settings, consult your DBMS documentation.
  12. Check the Autocommit check box to commit the database automatically after each SQL command. Otherwise the database will be committed only after an explicit commit statement. This setting is effective for all connected cursors.
  13. Check the Reprepare SQL commands check box to prepare and execute a SQL statement each time it is called. Otherwise Silk Performer prepares SQL statements only when necessary. This setting is effective for all cursors used in your test.
  14. Click OK to save your settings.
Parent topic: Database Settings