Add/Modify Connection (IBM)

Data source

Specify the name of the data source to connect to. If the name of the IBM data provider that you want to use is not displayed in this field, click Change to select your data provider.

Change

Opens the Change Data Source dialog box, in which you can select the IBM data provider for the .NET Framework.

Select or enter server name

Specify the server name to connect to. The server can be a combination of the server IP address or host name followed by a colon and a port number. Both IPv4 and IPv6 addresses are supported. You can also click Refresh to discover nearby IBM database servers.

Refresh

Refreshes the list of servers that are available in the Server field. The list of databases that are associated with each server is also refreshed.

User name

Type the user name to use to connect to the database.

Password

Type the password for the user name to connect to the database.

Save my password

Select this check box if you want Visual Studio to remember the password that you specify. By default, this check box is not selected.

Select or enter a database name

Type the name of the database to use for this data connection, or select the name from the list. If aliases are defined in the dsdriver.cfg file, they are displayed in the list.

Specify connection options

Click + to expand this section and show the connection options.

Automatic refresh of connection when IDE loads

Select this check box to automatically refresh the IBM data connection when you start a new session of Visual Studio. By default, this check box is not selected.

Run procedures to discover result sets

Select this check box to see result sets when you open procedure result set definitions. If this check box is selected, the add-ins run your procedure to discover the result sets. By default, this check box is selected.

Trusted context   [DB2^® for Linux^®, UNIX^®, and Windows^®, Version 9.5, Fix Pack 1, or later; Informix^® Dynamic Server (IDS), Version 11.70, or later]

A DB2 or IDS database administrator can define trusted contexts that identify connections as trusted connections. If your database administrator has defined a trusted context for you, the trusted context is established when you create the connection to the database and remains for the duration of the database connection.

User ID

Specify the system authorization ID that your database assigned for your trusted context.

Password

Specify the password for your system authorization ID.

Concurrent access resolution   (DB2 for Linux, UNIX, and Windows, Version 9.7, or later)

Specifies the concurrent access resolution to use for the connection. The selected choice specifies a prepare attribute that overrides the default behavior specified for cursor stability (CS) scans.

Currently committed

The database manager can use the currently committed version of the data for applicable scans when the data is in the process of being updated or deleted. Rows in the process of being inserted can be skipped.

Wait for outcome

Cursor stability and higher scans wait for the commit or rollback when encountering data in the process of being updated. Rows in the process of being inserted or deleted rows are not skipped.

Skip locked data

Currently committed semantics are used and rows in the process of being inserted are skipped.

Note:  This selection is not supported on DB2 Database for Linux, UNIX, and Windows. Selecting this choice for a DB2 for Linux, UNIX, and Windows database is the same as selecting None.

None

The client does not supply a prepare option. The currently committed behavior is determined by the database configuration.

Specify filtering options.

Click + to expand this section and show the filtering options.

Schema filter

You can limit the objects shown in the data connection to objects in specific schemas by typing either a schema name or a partial schema name. The search is performed as: LIKE <your_string>%

Exclude system schemas

If this check box is selected, the system schemas in your data connection are hidden. By default, this check box is selected.

Table type filter

To change the types of tables that are shown under the DB2 data connection, click and select the table types in the Select Table Type Filter dialog box.

Filter grid

Specify the filters that you want to apply for the data connection.

Include Folder

Select the check box for a folder to show the objects in the folder. By default, the check boxes for all folders are selected.

The check box selection for the XML Schema Repository folder is ignored.

Folder Name

The cells in this column show the names of each folder in the database.

Object Name Filter

If the check box for the folder is selected, you can limit the objects shown in the folder by typing either the name of an object or a partial name. The search is performed as: LIKE <your_string>%

Advanced

Opens the Advanced Properties dialog box, where you can specify values for the data connection properties.

Test Connection

Click to test if the password and user ID that you supplied can be used to connect to the target database.