If you have created DB2 Stored Procedures on an IBM iSeries (AS/400) that have a SPECIFIC name that differs from the PROCEDURE name, the BizTalk Adapter for DB2 does not correctly enumerate these Stored Procedures in the DB2 Adapter Schema Generation Wizard. For example, I created the following Stored...

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...

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...