Updated online documentation for the standalone OLE DB Provider for DB2 V3 included with the SQL Server 2008 R2 Feature Pack is available at the following location: http://msdn.microsoft.com/en-us/library/ee229549(v=SQL.10).aspx

If you are using HIS 2010 and want to communicate with IBM DB2 for z/OS V7, you might encounter the following issues. 1) The sample query in the Data Access Tool (DAT) or Data Source Wizard (DSW) fails with the following error: An internal network library error has occurred. The requested command included...

If you use the BizTalk Adapter for DB2 to connect to a DB2 system, you may see errors similar to the following in the application event log if you use a connection string that does not include a Default Schema: Event ID: 5743 Source: BizTalk Server Level: Warning Description: The adapter failed to transmit...

I recently received an email from someone trying to install the Microsoft OLE DB Provider for DB2 on a system running a 64-bit version of SQL Server 2005. The setup program returned the following error whenever they tried to install the DB2 Provider on this system: Unable to load Autorun.xml In addition...

If you create a Host File Project in Visual Studio to utilize the Managed Data Provider for Host Files included with Host Integration Server 2006, you may notice an issue if you are trying to use a host code page other than code page 37 (EBCDIC – U.S./Canada). After you add a Host File Library, you may...

The following error dialog may be displayed when using the Data Access Tool (DAT) included with Host Integration Server 2006 to create or edit a Universal Data Link (UDL): Note: This can also occur when using the Data Access Tool included with the Microsoft OLEDB Provider for DB2 versions that are bundled...