#Db2 data types list windows#

The Data Provider requires an IP address or IP alias in either IPv4 or IPv6 format, when you connect to the IBM DB2 database server by using a TCP/IP network connection. If you select TCP/IP Connection, click the ellipsis ( …) to open the dialog box for configuring TCP/IP Network Settings. Security Levelĭata Provider sends both a username and a password.ĭata Provider sends no security information (username or password). The following table describes security level settings.

Optionally you can specify the APPC conversation security to identify the Data Provider user to the DB2 database server. A common value for DB2/MVS is IBMRDB and DB2/400 is QPCSUPP. You must select or enter the name of the APPC local LU alias, APPC remote LU alias, and APPC mode name configured in Host Integration Server. If you select APPC Connection, click the ellipses ( …) to open the dialog box for configuring APPC Network Settings.

#Db2 data types list windows#

You must select TCP/IP Connection from the drop-down list, when connecting to DB2 databases that are running Linux, UNIX, or Windows operating systems. You can select either APPC Connection or TCP/IP Connection from the drop-down list, when you connect to DB2 databases that are running on host mainframe DB2/MVS and host midrange DB2/400 computers. The Data Provider supports TCP/IP network connections to remote IBM DB2 database servers that are running Linux, UNIX, or Windows operating systems. The Data Provider supports TCP/IP and SNA (Systems Network Architecture) over LU6.2 APPC (Advanced Program to Program Communications) network connections to remote IBM DB2 database servers that are running on IBM mainframe and midrange host computers. When you create a data link file by using the Data Source Wizard, the Data Source property names the Universal Data Link (UDL) file or connection string file. Specify a string to describe the data source. This section describes the properties that are specific to Microsoft OLE DB Provider for DB2 connections. Use the Connection tab to configure the basic properties required to connect to a data source.

Use the Provider tab to select the Microsoft OLE DB Provider for DB2 (the provider name string) from a list of possible OLE DB providers. This topic contains the following sections: To start the Data Access tool, click the Data Access Tool shortcut in the Host Integration Server program folder or click Start, Programs, Microsoft OLE DB Provider for DB2 and then Data Access Tool. You can then modify the UDL using the Data Links tool by opening the file from Windows Explorer, which loads the standard OLE DB Data Links user interface. You can create a data link by clicking the Data Access Tool shortcut in the Host Integration Server program folder. Data Links can save a data source definition as an OLE DB universal data link (UDL) file, which allows the user to share configurations between applications, users, and computers. Data consumers, such as Visual Studio and SQL Server, use the Data Links dialog to configure connections to IBM DB2 database servers.