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.

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.

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

Status

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×