Microsoft KB Archive/323803

From BetaArchive Wiki
Knowledge Base


BUG: Issues Related to Using ODBC Driver for DB2 with File DSNs

Article ID: 323803

Article Last Modified on 2/22/2007



APPLIES TO

  • Microsoft Host Integration Server 2000 Standard Edition



This article was previously published under Q323803

SYMPTOMS

The following issues have been identified when using the Microsoft ODBC Driver for DB2 with file data source names (DSNs):

  • An ODBC file DSN that is configured to use the Microsoft ODBC Driver for DB2 does not retain the DSN that is specified when the DSN is created. The Data Source Name value is blank when you use the ODBC Data Source Administrator to configure the file DSN.
  • The Connect button that is available in the ODBC Driver for DB2 Authentication dialog box when you configure the file DSN does not try to make an ODBC connection to the target database that is specified in the DSN.


CAUSE

  • The ODBC Driver for DB2 does not correctly parse the file DSN path, which results in the failure to retain the Data Source Name.
  • The ODBC Driver for DB2 was not designed to try to make an ODBC connection when you click Connect.


RESOLUTION

To resolve this problem, obtain the latest service pack for Host Integration Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

328152 How to Obtain the Latest Host Integration Server 2000 Service Pack


STATUS

Microsoft has confirmed that this is a problem in Microsoft Host Integration Server 2000. This problem was first corrected in Host Integration Server 2000 Service Pack 1.

Keywords: kbbug kbfix kbhostintegserv2000presp1fix kbhostintegserv2000sp1fix KB323803