Incorrect and misleading error message if initial catalog information is missing or incorrect

View products that this article applies to.

Symptoms

When you use Microsoft OLE DB Provider for DB2 with TCP/IP, and after you click the Test Connection button, you receive the following error message:

Test connection failed because of an error in initializing provider - RDB name not found or RDB name does not match Remote LU name.

SQLSTATE: HY000, SQLCODE: -360

NOTE: Although the cause for this behavior is described in the "Cause" section, this error message is misleading and incorrect. If the OLE DB Provider for DB2 is configured to use a TCP/IP connection, the error message is incorrect in refering to a "remote LU name". The remote LU name is used only if the provider is configured to use an Advanced Program to Program Communication (APPC) connection.

↑ Back to the top

Cause

The Microsoft OLE DB Provider for DB2 requires an Initial Catalog value when configuring this data link. If this value is left blank, or if an incorrect value is present, you receive the error message.

↑ Back to the top

Resolution

To resolve this behavior, use the correct Initial Catalog. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

218590 Configuring data sources for the Microsoft OLE DB provider

↑ Back to the top