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.

The Host Integration Server 2004 Data Access Tool (DAT) creates a copy of a data source name (DSN) when the DAT converts the DSN if the name already exists


View products that this article applies to.

Symptoms

When you convert a file data source name (DSN) to a system DSN in the Data Access Tool (DAT), the tool makes a copy of the data source if the name already exists as a System DSN. If you convert the File DSN a third time, DAT will add the characters "()". These characters are not valid in the Data Access Tool.

↑ Back to the top


Workaround

To work around this problem, rename the File DSN that you are converting to a name that does not exist as a System DSN.

↑ 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


More information

Microsoft is researching this problem and will post more information in this article when the information becomes available.

Steps to reproduce the behavior

1.Create a system DSN that is named Test.
2.Create a file DSN that is named Test.
3.Convert the file DSN to a system DSN, and then click Refresh.

↑ Back to the top


Keywords: KB884382, kbprb, kbhowto

↑ Back to the top

Article Info
Article ID : 884382
Revision : 2
Created on : 12/4/2007
Published on : 12/4/2007
Exists online : False
Views : 368