Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: Error message when you connect to DB2/400 by using the OLE DB Provider for DB2 over an SNA LU 6.2 session in a Host Integration Server 2010 environment: "Invalid User ID or password. SQLSTATE: 08S01, SQLCODE:-568"


View products that this article applies to.

Symptoms

You use the Microsoft OLE DB Provider for DB2 to connect to DB2/400 in a Microsoft Host Integration Server 2010 environment. When you use a network type of SNA LU 6.2 (APPC) for the connection to DB2, the connection may fail, and you receive the following error message:
Invalid User ID or password. SQLSTATE: 08S01, SQLCODE:-568

Note This problem can also occur when you use the Managed Provider for DB2 to connect to DB2/400.

↑ Back to the top


Cause

This problem occurs because the DB2 data provider incorrectly changes the password that is specified in the connection string to uppercase characters. This results in a logon failure.

↑ Back to the top


Resolution

The hotfix that resolves this issue is included in Cumulative Update 1 for Host Integration Server 2010.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2533330 Cumulative update package 1 for Host Integration Server 2010

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbnotautohotfix, kbqfe, kbfix, kbexpertiseinter, kbsurveynew, kbbug, kb

↑ Back to the top

Article Info
Article ID : 2559989
Revision : 1
Created on : 1/7/2017
Published on : 9/1/2011
Exists online : False
Views : 266