BUG: Desktop ODBC Drivers May Allow DSN to be Overwritten

Last reviewed: February 27, 1998
Article ID: Q181833

The information in this article applies to:

Microsoft Data Access Components, version 1.5

SYMPTOMS

When renaming an existing data source name (DSN), the Microsoft Desktop ODBC drivers allow you to overwrite an existing DSN without any warning. This occurs with the Microsoft Desktop ODBC drivers that ship with all versions of Microsoft Data Access Components (MDAC) version 1.5.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Expected Behavior

Open Control Panel and open the ODBC Administrator.
Create a User DSN going to a dBase source, and name it MyDSN.
Create a second User DSN going to a Paradox source and name it MyDSN.
This generates an expected error:
```
      The datasource named "MyDSN" already exists. Replace it with this
      definition?
```

Steps to Reproduce Behavior

Open Control Panel and open the ODBC Administrator.
Create a User DSN going to a dBase source and name it MyDSN.
Create a User DSN going to a Paradox source and name it MySecondDSN.
Highlight MySecondDSN, select "Configure..." and change the name to MyDSN.

The change is accepted, no warning dialog box is displayed and one of the DSNs has been removed.

Keywords          : mdac15Bug
Technology        : odbc
Version           : WINDOWS:1.5
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 27, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.