Configuring Data Sources for the OLE DB Provider for DB2

Microsoft OLE DB Provider for DB2 requires that data source information must be configured for any DB2 system that is to be accessed. A few default parameters are used when these parameters are not configured for each data source, but most parameters used for making connections to a specific DB2 system need to be configured.

The Microsoft Data Links, a core element of the Microsoft Data Access Components, provides a uniform method for creating file-persistent OLE DB data source object definitions in the form of Universal Data Link (UDL) files. Applications, such as the SQL Data Transformation Services used in this scenario, can open created UDL files and pass the stored initialization string to the OLE DB Provider for DB2 at run time.

UDL files are normally stored in a special system folder located at
C:\Programs Files\Common Files\System\Ole DB\data links

In order to use Microsoft OLE DB Provider for DB2 with an OLE DB application such as SQL Server DTS, the user must either (1) create a Microsoft data link (UDL) file and call this from the application, or (2) call the OLE DB provider from within the application using a connection string that includes the provider name ("DB2OLEDB") and any other needed parameters. For use in this scenario, we illustrate how to create a UDL file that can be used by DTS.

Previous Next